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/