Format a header when using Range()
 

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/

Format a header when using Range()
 

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?

Format a header when using Range()
 

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


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

Format a header when using Range()
 

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?