View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
need-A-hand[_2_] need-A-hand[_2_] is offline
external usenet poster
 
Posts: 1
Default formatting headers

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