L
Libby
How do I return the sheet tab name into a cell
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Bundy
You can modify =cell("filename")
if you just want the sheet use a right/find
if you just want the sheet use a right/find
M
Max
Libby said:How do I return the sheet tab name into a cell
Note: Workbook must be saved first
Try this technique taken from a post by Harlan ..
Click Insert > Name > Define
Put under "Names in workbook:": WSN
Put in the "Refers to:" box:
=MID(CELL("Filename",INDIRECT("A1")),FIND("]",CELL("Filename",INDIRECT("A1")))+1,32)
Click OK
The above defines WSN as a name we can use to refer to the sheetname in any
sheet. It will auto-extract the sheetname implicitly. Just enter: =WSN in any
sheet, any cell, and it'll return the sheetname in that cell.
L
Libby
exactly what I needed
thanx
--
Libby
thanx
--
Libby
Max said:Libby said:How do I return the sheet tab name into a cell
Note: Workbook must be saved first
Try this technique taken from a post by Harlan ..
Click Insert > Name > Define
Put under "Names in workbook:": WSN
Put in the "Refers to:" box:
=MID(CELL("Filename",INDIRECT("A1")),FIND("]",CELL("Filename",INDIRECT("A1")))+1,32)
Click OK
The above defines WSN as a name we can use to refer to the sheetname in any
sheet. It will auto-extract the sheetname implicitly. Just enter: =WSN in any
sheet, any cell, and it'll return the sheetname in that cell.