formatting headers/footers

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top