Macro code to add Autofilter for all sheets except certain ones

[Tapyr]

Hello,

I would like to add autofilter for all sheets (all of them have same layout and heading range: "B3-W3") except 3 sheets named: "Main Page", "Input Data", "Setup".

Could you pls help me with VBA code which should add it?

Thanks in advance for your help

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Tapyr]

Hi John, thanks a lot, however it doesn't work. Probably it will be caused because of my heading's range B3-W3. Since I am still VBA newbie I don't know overwrite this command.

.Range(.Cells(1, 1), .Cells(1, x)).AutoFilter

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

Instead.

[Tapyr]

Works perfectly. Thank you very much!!!!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.