I am really new at this and do not know how to use VBA or where to put the
code in Excel so I do not understand this answer. Basically I'd like to have
the code like what you can get in a custom header with a page number only
have it in a specific cell instead. Thank you for your response.

"Jacob Skaria" wrote:

intTemp = 1
ActiveSheet.PageSetup.CenterHeader = "Page " & intTemp
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True


If this post helps click Yes
---------------
Jacob Skaria


"compdinosaur" wrote:

I have a worksheet with a column heading cell with the words "Page Number".
I would like to be able to insert the automatic page number here when the
page prints. I tried
"Page Number &[Page]" , but this just printed literally.
[I am a newbie]