Auto Filter OFF in vba Code

[evertjvr]

Hi

I need to ensure that the Autofilter is not on on a list if data but the code

Please Login or Register  to view this content.

is extremely non descriptive

if is "On" then it will be switched " Off" and visa-versa.

also the "Selection." I have a problem with. I don't want to select as my data is on veryhiden worksheets and I never unhide it.

[jaslake]

Hi evertjvr

This should work

Please Login or Register  to view this content.

[evertjvr]

Thank You Jaslake - This works and I did not need to change the name of the worksheet as my data is on Sheet2

[jaslake]

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.