| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Page macro
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" -- Thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Page macro
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) On Wed, 18 Mar 2009 12:41:19 -0700, user wrote: 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" |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Page macro
..CenterFooter = "Page &P of &N"
Are you sure you have 5 pages in the printrange? Gord Dibben MS Excel MVP On Wed, 18 Mar 2009 12:41:19 -0700, user wrote: 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" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to open a web page through macro? | Excel Discussion (Misc queries) | |||
| Macro to launch web page | Excel Discussion (Misc queries) | |||
| Macro that copy page to page just some filled cells | Excel Discussion (Misc queries) | |||
| Using macro for page break | Excel Discussion (Misc queries) | |||
| Page break macro | Excel Worksheet Functions | |||
Linear Mode
