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.

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

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


--
Cheers
Nigel



"Paul" wrote in message
...
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.

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

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

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

Later
Dave

Nigel Wrote:

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

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



--
Piranh
-----------------------------------------------------------------------
Piranha's Profile: http://www.excelforum.com/member.php...fo&userid=2043
View this thread: http://www.excelforum.com/showthread.php?threadid=37646