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

Hello,
I wonder if you can help me

I know how to format a string within a header

eg:
sheet1.pagesetup.centerheader="&""ariel,bold"&""&1 4HELLO"
formats the word HELLO to bold and size 14

However, instead of HELLO, I need to put in a variable
which represents a date.
If anyone can help I'd be very grateful

Many thanks
Geoff