Page macro

[user]

When my macro runs, I want the page number to show "1 of 5" on 1st page and
"2 of 5" on 2nd page. This is what I have so far, but its printing 2of2, not
2of5. Also, how do I correctly put "of" in.
.CenterFooter = "&P&[of]&P"

 

[Chip Pearson]

Use

&[Page] Of &[Pages]

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Gord Dibben]

..CenterFooter = "Page &P of &N"

Are you sure you have 5 pages in the printrange?


Gord Dibben MS Excel MVP