link the tab name to a cell
 

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

link the tab name to a cell
 

Hi,
use the following formula:

=RIGHT(CELL("FILENAME",F10),LEN(CELL("FILENAME",F1 0))-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" wrote:

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

link the tab name to a cell
 

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

Coastie

"xlbo" wrote:

Hi,
use the following formula:

=RIGHT(CELL("FILENAME",F10),LEN(CELL("FILENAME",F1 0))-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" wrote:

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