Worksheet Name Reference

[jtk911]

How do I reference the name of the worksheet in a cell within the worksheet itself?

Example: "Worksheet (2)" is the name fo the worksheet.
How do I get Worksheet (2)" to appear in a cell which references the tab name?
So when they change the tab name it changes the cell result.

Thanks.

 

[MickG]

Try:-

=RIGHT(CELL("Filename"),LEN(CELL("Filename"))-(FIND("]",CELL("Filename"))))

Mick

 

[jtk911]

Thanks, it works; however, it changes in all cell whenever a worksheet name is changed. Only when you highlight the worksheet name will it correct itself. Anything I can do about this?

 

[MickG]

Hi, I understand the problem, but unfortuately I don't know the answer.
Regards Mick

 

[GlennUK]

Try:

=RIGHT(CELL("Filename",$A$1),LEN(CELL("Filename",$A$1))-(FIND("]",CELL("Filename",$A$1))))

 

[MickG]

Thanks Glen, thing become clearer when you read the instructions on the packet,:- ("Cell")
Regards Mick

 

[GlennUK]

Thanks Glen, thing become clearer when you read the instructions on the packet,:- ("Cell")
Regards Mick

ha ha, yes, I know the feeling!