Turn filter off whether its already on or off

[robertguy]

Hi,


can anyone please advise me of the macro code I need to look at the active sheet and turn the filter off on row 1 which could be turned on or already turned off


many thanks in advance

Regards


Rob

N.B. Excel version 2007

[Ace_XL]

Try

Please Login or Register  to view this content.

or simply

Please Login or Register  to view this content.

[robertguy]

Ace_XL,

many thanks for you help, just what I wanted

Thanks again

Rob