PDA

View Full Version : Page number in cell



adamsm
05-23-2011, 11:08 AM
Hi,

How could I write a formula or vba code that would place the page number in cell O8 of the active sheet when the sheet prints?

Any help on this would be kindly appreciated.

Thanks in advance.

Jan Karel Pieterse
05-23-2011, 11:54 PM
This may give you some idea's:
http://www.dailydoseofexcel.com/archives/2004/12/22/page-of-pages-in-a-cell/

adamsm
05-24-2011, 10:52 AM
Thanks for the help. I do really appreciate it.