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]

On Tue, 7 Apr 2009 19:51:01 -0700, 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]


In the print setup, headers tab, choose custom header, and place the
&[Page] command in there. You can place spaces after it to space it in
from the right edge,and you adjust the header placement to change its
vertical placement.

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]

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]

I know how to get the page numbering in a custom header like you said, but
I'd like to get the same result in a cell that is in a Print Title column
that prints on the top of each page rather than the standard header. [I do
not know how to use VBA]
Thank you for your response.

"AnimalMagic" wrote:

On Tue, 7 Apr 2009 19:51:01 -0700, 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]


In the print setup, headers tab, choose custom header, and place the
&[Page] command in there. You can place spaces after it to space it in
from the right edge,and you adjust the header placement to change its
vertical placement.