can excel display current page in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to display the current page in a cell on a speadsheet. I can not use the headers or footers.
 
Tony,

=RIGHT(CELL("Filename",A1),LEN(CELL("Filename",A1))-FIND("]",CELL("Filename"
,A1),1))

Mind however that this will work after the file is saved.!!
The Cell function then returns the filename+sheetname including the path.
The rest of the formula is there to extract the sheetname from that info.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

tony said:
I need to display the current page in a cell on a speadsheet. I can not
Click to expand...
use the headers or footers.
 
Back
Top