link the tab name to a cell

C

Coastie

I'm trying to link the sheet name tab to a cell, so when I change the tab
name the contents of the cell changes to match
 
X

xlbo

Hi,
use the following formula:

=RIGHT(CELL("FILENAME",F10),LEN(CELL("FILENAME",F10))-FIND("]",CELL("FILENAME",F10)))

note - the workbook must have been saved at least once for this to work. If
you create a new workbook and enter the formula without 1st saving, it will
fail
--
Rgds, Geoff

"A crash reduces
Your expensive computer
To a simple stone"
 
C

Coastie

Thanks, xlbo...
I could never have worked that out myself.
Kind regards and keep safe.

Coastie

xlbo said:
Hi,
use the following formula:

=RIGHT(CELL("FILENAME",F10),LEN(CELL("FILENAME",F10))-FIND("]",CELL("FILENAME",F10)))

note - the workbook must have been saved at least once for this to work. If
you create a new workbook and enter the formula without 1st saving, it will
fail
--
Rgds, Geoff

"A crash reduces
Your expensive computer
To a simple stone"


Coastie said:
I'm trying to link the sheet name tab to a cell, so when I change the tab
name the contents of the cell changes to match
Click to expand...
Click to expand...
 
Top