Thread: How to insert page number and number of page.....
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Piranha[_8_] Piranha[_8_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote