VBA to check if filters are on

[Johnno1]

Hi

I'm looking for simple VBA code to check if the Active Sheet has Autofilter filters that are active - - if there are any active filters I intend to use the Show All Data property

Cheers

Johnno1

[Andrew-R]

You can check the AutoFilterMode for the active sheet ...

Please Login or Register  to view this content.

[tlafferty]

If you trap for the error, you won't need to check whether or not there are any filters:

Please Login or Register  to view this content.