Jeff Smith wrote:
My code is

"Some""Arial""&9"


To get xyz in Arial 9 point

ActiveSheet.PageSetup.LeftHeader = "&""Arial""&9xyz"

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup