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

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