Excel Header Formatting

[yussi1870]

In my VB Code I need to copy the header from one worksheet to another and then reformat the font size and font name but I can't seem to strip the old formatting out. Any ideas?

 

[Al Chara]

Try the following code:

With Worksheets("New Worksheet").PageSetup
.CenterHeader = "&""Times New Roman,Regular""&8The Old Header"
End With

This code sets the center header for a worksheet called "New Worksheet" to the text "The Old Header" in regular 8 point Times New Roman font.