switching autofilter on or off with macro

[guerilla]

Hello,

If I want to check a number of sheets in a workbook and switch autofilter off if it is on, how would I go about this (using a macro)?

Later I would also need to turn it on in certain worksheets.

regards,

Matt

[Carim]

Hi Matt,

Please Login or Register  to view this content.

HTH
Carim

[guerilla]

Thanks that did the trick.

Matt

[Carim]

You are welcome

Thanks for the feedback

Carim