Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell to contain page name
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! -- Daniel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell to contain page name
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 --- 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 "Daniel Lidström" wrote in message ... 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! -- Daniel |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell to contain page name
"David McRitchie" wrote...
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 Thanks, this is what it turned out to be in my swedish version: =EXTEXT(CELL("filnamn";A1);SÖK("]";CELL("filnamn";A1))+1;255) -- Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When automatic page breaks are moved each cell becomes a new page | Excel Discussion (Misc queries) | |||
change cell size from page to page on the same worksheet | Excel Worksheet Functions | |||
sheet tabs as page number and in a cell page of pages? | Excel Discussion (Misc queries) | |||
cell on one page equals cell on another page in excel? | Excel Worksheet Functions | |||
How do I move the data in one cell on a page to another page/cell | Excel Discussion (Misc queries) |