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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks