I want to add a header as below. However, I want to replace the word "Test"
with a variable. How do I do that and still retain the formatting?
With ActiveSheet.PageSetup
.CenterHeader = "&""Arial,Bold""&14Test"
End With
Thanks
I want to add a header as below. However, I want to replace the word "Test"
with a variable. How do I do that and still retain the formatting?
With ActiveSheet.PageSetup
.CenterHeader = "&""Arial,Bold""&14Test"
End With
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks