Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link page header with cell contents | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Link to Cell Not Updating | Excel Worksheet Functions | |||
hyperlink - link one cell to another in a worksheet. how? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |