Try something like

ActiveSheet.PageSetup.LeftHeader = Format(Date, "dd mmm yyyy")


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Musicguy" wrote in message
...
Is there a way to place a variable I named in my code into a header and
add some formatting?
Thanks for the help!