adding/removing auto filter 1

[maclav]

Hi
I am quite experienced with using vb to make excel do what i want but have come up against a peculiarity i was hoping some one could clear up.
It look to me like the code that adds an auto filter to a selection is also the same as the code to get rid of it.
Is there some code I could put in an if to say:
if auto filter is there then run the code
and visa versa depending on the situation
Thanks for any help

 

[combo]

For Range object AutoFilter method (without parameters)toggles the autofilter. For Worksheet object returns AutoFilter object. To test:
MsgBox Not ActiveSheet.AutoFilter Is Nothing


combo

 

[maclav]

Brilliant. That did what i needed.
Thanks

 

[combo]

A simpler approach:
MsgBox ActiveSheet.AutoFilterMode

combo