set header font size using a variable?
If you record a macro you get:
..CenterHeader = "&""Times New Roman,Regular""&36ATTACHMENT I"
so to replace the 36 you need
..CenterHeader = "&""Times New Roman,Regular""&" & FS & "ATTACHMENT I"
the first ampersand after ",Regular" is part of the string, the second is
the concatenation operator
--
Regards,
Tom Ogilvy
"Seth" wrote in message
...
I am trying to set the header font size to a variable (I just am using a
constant in this example), but am having no luck getting it to print. I
have
tried many attempts but am not getting what I need. So far I get no
header
or some other formatting (time, strikethrough, etc). Please help. Thanks
in
advance.
FS = 36
.CenterHeader = "&""Times New Roman,Bold" & FS & "ATTACHMENT I"
does not work
.CenterHeader = "&""Times New Roman,Bold""&FSATTACHMENT I"
does not work either
|