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]