Appying a Macro to all sheets in a workbook at the same time.

[Ghostwheel]

I have a workbook with Sheets numbered T1 through T200, I'm using the following macro.
Option Explicit

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Is there a way to include all the sheets in the work book starting with the letter T without listing all the sheets individually as above.

Thank you,

Eric

[arlu1201]

It will be good if you try and explain what you are trying to do.

[ragavan.sridar1]

try this.

Please Login or Register  to view this content.

[Ghostwheel]

arlu1201,

I'm using the Sheet Format Template page as a master to apply any changes to the format or layout to all the other T named sheets in the work book, So if I need to update the primary form layout I can do it with all the other sheets at the same time.

Eric

[Ghostwheel]

Raga,

That works somewhat, I moved my master sheet over 7 letters so the changes do not affect my information sheet as well as the rest of the sheets. So it gets me through the hurdle.

Thanks

Eric