formatting headers/footers

[Guest]

Where can I find documentation on formatting headers and footers? I've found
an example that sets the font and size, but haven't been able to figure out
how to set bold and/or italics and do a line feed.

 

[Guest]

The best way is to turn the Macro Recorder 'On' and set the Header, then
study the generated code.

Eg: I wrote in the header:
this time i
what do you
on two line with the part 'i what' in bold arail 11pt
also i inserted a new line after the 'i' --> chr(10)
Here is the generated code:
ActiveSheet.PageSetup.LeftHeader = _
"this &""Arial,Bold""&11time i" & Chr(10) & "what &""Arial,Regular""do
you"

 

[Guest]

Thanks Sebastien. Excellent suggestion. It worked like a charm.

Larry