| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Page footer
I would like to add the page footer using code.
This is what it looks like using the add footer menu's - Page &[Page] of &[Pages] (Page1 of 10). I have been trying many different possibilities with no luck and cannot find an example of this same thing here. Any help is appreciated. Thanks, Ron |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Page footer
Use this line:
ActiveSheet.PageSetup.RightFooter = "Page &P of &N" Hope this helps! If so, click "YES" below. -- Cheers, Ryan "Ron5440" wrote: I would like to add the page footer using code. This is what it looks like using the add footer menu's - Page &[Page] of &[Pages] (Page1 of 10). I have been trying many different possibilities with no luck and cannot find an example of this same thing here. Any help is appreciated. Thanks, Ron |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Page footer
Exactly what I needed!
Thanks, Ron "Ryan H" wrote: Use this line: ActiveSheet.PageSetup.RightFooter = "Page &P of &N" Hope this helps! If so, click "YES" below. -- Cheers, Ryan "Ron5440" wrote: I would like to add the page footer using code. This is what it looks like using the add footer menu's - Page &[Page] of &[Pages] (Page1 of 10). I have been trying many different possibilities with no luck and cannot find an example of this same thing here. Any help is appreciated. Thanks, Ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format page number in excel footer to start at a specific page # | Excel Discussion (Misc queries) | |||
| Unique Footer for each page in worksheet with a page number | Excel Worksheet Functions | |||
| print footer on every page (Totals on every page) | Excel Discussion (Misc queries) | |||
| Footer on last page? | Excel Discussion (Misc queries) | |||
| header and footer on every page except the first page? | Excel Discussion (Misc queries) | |||
Linear Mode
