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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates-Automatically entered in cells 7
Excel in a Web page 1
Excel Sum numbers in cells that also contain text 34
no of pages in excel worksheet (not workbook) 9
Headers & Footers _auto update info from a cell in the worksheet 4
Excel 2007 Header Doesn't Print 1
How to increment page number in a cell of worksheet 2
Extracting partial information from a cell 2

Back
Top