formatting headers

N

need-A-hand

Hi

I know that

sheet1.pagesetup.centerheader = "&""ariel,bold""&12HELLO"

puts HELLO in the header and formats it to bold and font
size 12.

How do I replace the HELLO with a variable, as on my
spreadsheet the header is a date variable that is changed
just prior to the sheet being printed?

All help much appreciated
 
Top