Formatting Codes for header and footer

  • Thread starter Thread starter chambers777
  • Start date Start date
C

chambers777

How can I use VBA to change the formatting of an already formatte
Header???

Dim Value
Value = ActiveWorkbook.Worksheets(1).PageSetup.CenterFooter
ActiveWorkbook.Worksheets(1).PageSetup.CenterFooter
"&""Courier""" & Value

I've used this, but it doesn't remove the previous formatting whic
stays in tact
 
Remove value = from the start of your code

ActiveWorkbook.Worksheets(1).PageSetup.CenterFooter
ActiveWorkbook.Worksheets(1).PageSetup.CenterFooter = "&""Courier""" &
Value
 
This code:
Dim Value
ActiveWorkbook.Worksheets(1).PageSetup.CenterFooter
ActiveWorkbook.Worksheets(1).PageSetup.CenterFooter = "&""Courier""" &
Value

Returns "CenterFooter method of PageSetup class failed"
 
Back
Top