View Single Post
  #2 (permalink)  
Old December 16th, 2003, 05:25 AM
gcianfanelli gcianfanelli is offline
Authorized User
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts

You can set the font name/size by setting a string value such as

 &"Arial"&8 My Header

ActiveWorkbook.Worksheets(1).PageSetup.LeftHeader = "&""Arial""&8 My Header"

this sets the left-hand header to "My Header" in Arial 8 point
Reply With Quote