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

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/

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/