Finding the Sheet Name on Named Tabs

[spyldbrat]

Hello,

If I were to rename "Sheet 1" to "My Tab", is there a way for me to find out that "My Tab" is actually "Sheet 1"?

 

[Fluff]

When you say "Sheet 1" are you referring to the sheet name, the sheet index, or the sheet codename?

 

[Rick Rothstein]

Hello,

If I were to rename "Sheet 1" to "My Tab", is there a way for me to find out that "My Tab" is actually "Sheet 1"?

As long as you have not changed the CodeName of the sheet, you can use that to determine the original name of the sheet.

MsgBox Sheets("My Tab").CodeName

 

[spyldbrat]

I am looking for the sheet name.

what Rick provided will not work. I am getting error and it's referencing "sheet 3". I don't which tab is sheet 3.

 

[Fluff]

AFAIK once you have changed the sheet name, there is no way of finding out what it was previously called.

 

[Rick Rothstein]

I am looking for the sheet name.

what Rick provided will not work. I am getting error and it's referencing "sheet 3". I don't which tab is sheet 3.

First off, unless you went through the trouble of physically changing each tab, your original sheet names do not have a space in front of the number, so it would be "Sheet3", not "Sheet 3"). Second, you originally asked "is there a way for me to find out that 'My Tab' is actually 'Sheet 1'?" which is what the code I gave you did. Your latest message makes it appear that your original question should have been "is there a way to find out what name currently appears on the tab for the sheet originally named Sheet1?". Try this...

MsgBox Sheet1.Name