Reference a tab label in a cell

[WONGMEISTER]

Is this possible?

I simply want to reference the tab label name in a cell. When I change the tab name, I want the cell to change also.

Thanks.

 

[VoG]

Save the file first then

<code>=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))</code>

 

[WONGMEISTER]

VoG!!!!!!!!!!!

THAT IS SO COOOOL!!!!

Thank you so much.

Have a great day!

Wongmeister.

 

[T. Valko]

Is this possible?

I simply want to reference the tab label name in a cell. When I change the tab name, I want the cell to change also.

Thanks.

Here's another one...

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,31)

The file must have beeen saved and given a name for this to work.

 

[WONGMEISTER]

Thanks Biff also.

I can't say enough how many times I've wondered about this.