Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CELL("Filename")
Hi
If I use the following worksheet function on several sheets why does it not show the correct tab name on each individual sheet but only show the last tab name where I've select the cell and pressed F2 and return so commit a recalc MID(CELL("Filename");FIND("]";CELL("Filename");1)+1;LEN(CELL("Filename"))-FIND("]";CELL("Filename");1) Or is there a better way to show in a cell the tab name e.g. I want to use it in a title and yes I know I could can show it in a custom header but that would appear in the header and not on the sheet Thanks in advanc best regard KM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CELL("Filename")
Hi Kevin,
You *must* supply a cell reference for the worksheet you =CELL("Filename",A1) Read more at http://www.mvps.org/dmcritchie/excel/pathname.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Kevin McCartney" wrote in message ... Hi, If I use the following worksheet function on several sheets why does it not show the correct tab name on each individual sheet but only show the last tab name where I've select the cell and pressed F2 and return so commit a recalc. MID(CELL("Filename");FIND("]";CELL("Filename");1)+1;LEN(CELL("Filename"))-FIND("]";CELL("Filename");1)) Or is there a better way to show in a cell the tab name e.g. I want to use it in a title and yes I know I could can show it in a custom header but that would appear in the header and not on the sheet. Thanks in advance best regards KM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELL("filename") doesn't work on shortcut workbook link? | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
CELL("filename") acting Volatile? (in assoc. with PULL) | Excel Worksheet Functions |