Format a header when using Range()

[anae]

I want to use cell values in my header AND I want to be able to format
them too. This is what I know to do so far:

ActiveSheet.PageSetup.RightHeader = _
Format(Worksheets("Sheet1").Range("A1").Value)

I know you can format text using ampersands and quotation marks, but
you actually have to type out the text.

How do you handle formatting when Range().Value is involved?

There must be a way to do this even though the Microsoft Knowledge base
doesnt address the fact that you might want to do both.

Any ideas? Is it possible to pre-format the Header before you
introduce any values or text?

 

[JE McGimpsey]

Just concatenate your print header formats and your cell text:

ActiveSheet.PageSetup.RightHeader = _
"&08&b" & Worksheets("Sheet1").Range("A1").Text

 

[ravz]

Can you provide some more details on this one?? perhaps a simple
formated header example?

 

[JE McGimpsey]

I did in my post. Did you have a particular question?