Cell to contain page name

  • Thread starter Thread starter Daniel Lidström
  • Start date Start date
D

Daniel Lidström

Hello,

how do I put the name of the page of the workbook in a cell? I wish to be
able to only change the name of a page and the cell should adjust.
Thanks!
 
Hi Daniel,
Expect you mean worksheet name. At least in English, nothing has the
name of page in Excel except when referring to printing or HTML pages.
Perhaps you are translating the equivalent of "sheet" to "page".

Enter the following exactly as typed.
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

For other examples see
Pathname in headings, footers, and cells
http://www.mvps.org/dmcritchie/excel/pathname.htm
 
David McRitchie said:
Hi Daniel,
Expect you mean worksheet name. At least in English, nothing has the
name of page in Excel except when referring to printing or HTML pages.
Perhaps you are translating the equivalent of "sheet" to "page".

Enter the following exactly as typed.
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

For other examples see
Pathname in headings, footers, and cells
http://www.mvps.org/dmcritchie/excel/pathname.htm
Click to expand...

Thanks, this is what it turned out to be in my swedish version:
=EXTEXT(CELL("filnamn";A1);SÖK("]";CELL("filnamn";A1))+1;255)
 
Back
Top