How to insert page number and number of page.....

I need to insert the page number and total number of pages (Page 1 of 11) at
the bottom of an Excel report just like a footer, using vba. Thanks.

ActiveSheet.PageSetup.CenterFooter = "Page: &P of &N"


--
Cheers
Nigel



"Paul" <paul_mak@hotmail.com> wrote in message
news:%23DfjsGJaFHA.2308@TK2MSFTNGP14.phx.gbl...
> I need to insert the page number and total number of pages (Page 1 of 11)
at
> the bottom of an Excel report just like a footer, using vba. Thanks.
>
>

Hi Paul,
You can use one of these for positioning.

.LeftHeader or .CenterHeader or .RightHeader
.LeftFooter or .CenterFooter or .RightFooter

Later
Dave

Originally Posted by Nigel

ActiveSheet.PageSetup.CenterFooter = "Page: &P of &N"
--
Cheers
Nigel

"Paul" <paul_mak@hotmail.com> wrote in message
news:%23DfjsGJaFHA.2308@TK2MSFTNGP14.phx.gbl...
> I need to insert the page number and total number of pages (Page 1 of 11)
at
> the bottom of an Excel report just like a footer, using vba. Thanks.
>
>