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
|