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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Style Header Reformatted 3
Font in Header - @22 "25 Miles" goes to 409 font 1
formatting headers 2
Book formatting: need to alternate page number on left and right margin for only first page of each 2
Apply cell formatting using VBA 2
Format Center Header 1
Macro to Format Multiple Sheets based on "Master" Format 0
Remove Hyperlinks Without Changing background shading 14

Top