CELL("Filename")

[Kevin McCartney]

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

 

[David McRitchie]

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

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.