View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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