VBA test to see if autofilters are on?

[chuckles1066]

Evening all,

What's the code?

I need to test if autofilters are on and, if so, turn them off.

From what I can see from the macro recorder, it seems to be a crude, simple line that will apply autofilters if they aren't on or remove them if they are.

TIA.

 

[Jonmo1]

There's really no need to test if they are on...
Just turn them off, the code won't error if they are NOT on...

ActiveSheet.AutoFilterMode = False

 

[chuckles1066]

Many thanks, much appreciated.

 

[Jonmo1]

Glad to help, thanks for the feedback.