Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programatically set up footer
How can I programatically configure page numbers based on a worksheet
that has the correct page number for the corresponding worksheet? Example: Each worksheet in workbook is one page, but the pages change fairly often. I want to keep a "master page number" worksheet that can be updated easier than going into each worksheet and setting the footer. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programatically set up footer
Never mind:
This works. Sub UpdateFooter() ActiveSheet.PageSetup.Leftfooter = Range("A1").Value End Sub http://support.microsoft.com/kb/273028 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programatically set up footer
Thanks for the information Epoh.
-- Jay "Epoh Rio" wrote: Never mind: This works. Sub UpdateFooter() ActiveSheet.PageSetup.Leftfooter = Range("A1").Value End Sub http://support.microsoft.com/kb/273028 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel footer to look like Word footer? | Excel Discussion (Misc queries) | |||
Printing to header/footer programatically | Excel Programming | |||
Set dropdown programatically | Excel Programming | |||
Programatically set ref to my DLL | Excel Programming | |||
Landscape Orientation when Footer set using mso-footer-data Disappear | Excel Programming |