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?


---
Message posted from http://www.ExcelForum.com/

Just concatenate your print header formats and your cell text:

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

In article ,
anae wrote:

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?

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


---
Message posted from http://www.ExcelForum.com/

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

In article ,
ravz wrote:

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