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




Reply With QuoteReply With Quote