| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Header & Footer
I am using Excel 97.
Is there a way to capture the contents of the CenterHeader & CenterFooter on a worksheet and use them programmatically in VBA elsewhere? If so, can someone assist with some code, please? Regards Mark |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Header & Footer
Hi Mark
use something like sub foo() dim vfooter with activesheet.pagesetup vfooter=.centerfooter end with msgbox vfooter end sub -- Regards Frank Kabel Frankfurt, Germany Mark wrote: I am using Excel 97. Is there a way to capture the contents of the CenterHeader & CenterFooter on a worksheet and use them programmatically in VBA elsewhere? If so, can someone assist with some code, please? Regards Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Header and Footer | Excel Discussion (Misc queries) | |||
| Header/Footer | Setting up and Configuration of Excel | |||
| Header and Footer | Excel Worksheet Functions | |||
| Header and Footer | Excel Worksheet Functions | |||
| Changing (Part of) Header Without Changing Footer or Rest of Header | Excel Programming | |||
Linear Mode
