Home |
Search |
Today's Posts |
#1
|
|||
|
|||
insert a page number into a cell?
Is it possible to enter the page number into a cell? I am wanting to insert
a page number as part of a formula. I know looked up the code for inserting page numbers in the header and footer, and it doesn't work... this is the formula: =(CHAR((CODE(A$10))))&" - Page "&[Page]&" of "&[Pages] Please Help Me!!! |
#2
|
|||
|
|||
Why don't you use page break view?
-- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "Carrmuha" wrote in message ... Is it possible to enter the page number into a cell? I am wanting to insert a page number as part of a formula. I know looked up the code for inserting page numbers in the header and footer, and it doesn't work... this is the formula: =(CHAR((CODE(A$10))))&" - Page "&[Page]&" of "&[Pages] Please Help Me!!! |
#3
|
|||
|
|||
Hi
there's no easy solution for this and it would require VBA. You have to calculate depending on your printer and printer setting where the pagebreaks ´would occur. So I would also go with Peo's suggestion or use the header/footer -- Regards Frank Kabel Frankfurt, Germany "Carrmuha" schrieb im Newsbeitrag ... Is it possible to enter the page number into a cell? I am wanting to insert a page number as part of a formula. I know looked up the code for inserting page numbers in the header and footer, and it doesn't work... this is the formula: =(CHAR((CODE(A$10))))&" - Page "&[Page]&" of "&[Pages] Please Help Me!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Challenging Charting | Charts and Charting in Excel | |||
I need to increase a number which is held in a cell by 1 | New Users to Excel | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
#VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
parse cell and insert rows? | Excel Worksheet Functions |