Renaming tabs with a macro

[Darnell86]

Good Morning All,

I am still new to this forum and I just recently had one of my questions answered and I have stumbled onto another mystery!

I have used a macro in the past to rename all of my tabs in an excel without having to click and rename all tabs. The macro itself changes the name of the tab from what is typed into a specific cell.

I am wondering if there is a way to change this macro (that I will post below) to rename a tab to what it is being displayed in the cell rather than what is typed in the cell because it is a formula... The cell I am trying to use in B2 has a formula but displays a date 5-1-2020.

The reason I want to do this is because I want to basically make this a template so all i have to do is change 1 or 2 things and not have to change 40-50 things every month.

Macro:

Please Login or Register  to view this content.

Currently I am receiving an error because it is trying to pull the formula which is either to long or contains invalid characters.

[TMS]

Maybe try:

Please Login or Register  to view this content.

[Darnell86]

TMS,

Thank you so much for your help and your speedy response. This worked perfectly!

This is very much appreciated.