| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formatting Codes for header and footer
How can I use VBA to change the formatting of an already formatte
Header??? Dim Value Value = ActiveWorkbook.Worksheets(1).PageSetup.CenterFoote r ActiveWorkbook.Worksheets(1).PageSetup.CenterFoote r "&""Courier""" & Value I've used this, but it doesn't remove the previous formatting whic stays in tact -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formatting Codes for header and footer
Remove value = from the start of your code
ActiveWorkbook.Worksheets(1).PageSetup.CenterFoote r ActiveWorkbook.Worksheets(1).PageSetup.CenterFoote r = "&""Courier""" & Value --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Formatting Codes for header and footer
This code:
Dim Value ActiveWorkbook.Worksheets(1).PageSetup.CenterFoote r ActiveWorkbook.Worksheets(1).PageSetup.CenterFoote r = "&""Courier""" & Value Returns "CenterFooter method of PageSetup class failed" --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HEADER and FOOTER | Excel Worksheet Functions | |||
| Header/Footer | Excel Discussion (Misc queries) | |||
| Copy Header/Footer to Retain Formatting | Excel Discussion (Misc queries) | |||
| Header & Footer | Excel Worksheet Functions | |||
| Formatting Date in Header & Footer | Excel Discussion (Misc queries) | |||
Linear Mode
