AutoFilter Macro

[Jan Nademlejnsky]

I need a macro which turns AutoFilter (Selection.AutoFilter) off if it is
on, but does nothing if it is off.

Thanks for your help.

Jan

 

[Debra Dalgleish]

ActiveSheet.AutoFilterMode = False

I need a macro which turns AutoFilter (Selection.AutoFilter) off if it is
on, but does nothing if it is off.

 

[Jan Nademlejnsky]

Hi Debra,

Thank you very much. I should have asked this question a long time ago to
save my agony.

This works perfectly.

Jan

 

[Debra Dalgleish]

You're welcome! Another way to find answers to those agonizing questions
is in Google. Ron de Bruin has a nice Google search add-in:

www.rondebruin.nl/Google.htm