Excel: Putting the name of the sheet in a cell without Macros

[mikemmd]

What? If a sheet is called "my tab 1", I wand the cell (eg) A1 to have "my tab 1" in it.

How? Simply enter: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,30)
Changing the tab's name to "my tab 2" changes the value of A1 to "my tab 2" automatically. Et voila!

Caution: a lot of threads on the web omit the A1 in the Cell formula, which makes the formula return the last tab it has been applied to (not what is wanted if there are many tabs with this formula). Hope this will be useful to some of you!

 

[SkipVought]

Michael,


Welcome to Tek-Tips.

You need to understand what kind of site Tek-Tips is. Rather than bursting thru the door and posting what you think is a great find, you need to spend some time seeing how this site works. You would have seen that xlbo has posted faq68-2561.

Stick around and learn something.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[mikemmd]

You are right Skip, I was not aware of xlbo's thread. Hopefully though, this thread will help other people finding the "right" formula/solution.

 

[SkipVought]

The point is, that it was not a thread, but a FAQ, where such general tips are posted.

Please become familiar with this site.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}