Thread
:
Working with headers in pagesetup
View Single Post
#
2
Posted to microsoft.public.excel.programming
William[_2_]
external usenet poster
Posts: 227
Working with headers in pagesetup
Hi Okie
With ActiveSheet.PageSetup
..CenterHeader = "&""Arial,Bold""&14" & _
ActiveSheet.Range("M1")
End With
--
-----
XL2003
Regards
William
"OkieViking" wrote in message
...
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
Reply With Quote
William[_2_]
View Public Profile
Find all posts by William[_2_]