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" <[email protected]> wrote in message
news:%[email protected]...
> 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" <[email protected]> wrote in message
news:%[email protected]...
> 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.
>
>