Variables in headers

M

Musicguy

Is there a way to place a variable I named in my code into a header and add some formatting
Thanks for the help!
 
B

Bob Phillips

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)
 
Top