Loop through Tabs

[terischmig]

I want to LOOP through all the Tabs within a worksheet to change the Tab name to the name of a specific cell. I have a Macro that will do this for one Tab at a time, but I have 100 to 200 tabs per workbook.

Thank you for your help,
Teri Schmig

[Palmetto]

Here is the basic approach, adapt as required. It assumes cell A1 on each sheet contains the value by which to name the sheet.

Please Login or Register  to view this content.

[shg]

Here's one way:

Please Login or Register  to view this content.

[terischmig]

I used Palmetto's code and it worked great - thanks!