| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Page Number in a cell | Excel Worksheet Functions | |||
| how do i insert page number on active cell? | Excel Discussion (Misc queries) | |||
| how to insert a page number in a cell | Excel Worksheet Functions | |||
| HOW DO I INSERT PAGE NUMBER IN A CELL ? | Excel Discussion (Misc queries) | |||
| insert a page number into a cell? | Excel Worksheet Functions | |||
Hybrid Mode
