Run a macro across all but 3 specific worksheets

I have a Workbook with a variable number of Worksheets (anywhere between 5 and 100 different sheets). The Worksheets to which I apply the macro are largely identical in structure. I would like to run the following macro against all but 3 specific Worksheets. The 3 Worksheets are constant and will always have the same names, "Global Inputs", "Summary" and "Tie-In Worksheet".

The code below was not my creation but I copied and adapted it for my use and it works well, albeit for a single active Worksheet.

Please Login or Register  to view this content.

I will be very grateful for any suggestions. I am glad to send a sample Workbook if that would help.

Thanks,
Dino

Hi Dino,

Welcome to the forum!!

See how this goes:

Please Login or Register  to view this content.

Regards,

Robert

Hi Dino,

Try this where the ranges are cleared just before the code is re-run for each tab:

Please Login or Register  to view this content.

Regards,

Robert

Thanks for the feedback and you're welcome