Hi there,
Have poked around a bit for an answer as well as attempted a few different iterations with no luck. I'm trying to produce a left header that is both (1) formatted a particular way AND (2) linked to a particular cell. For the latter, I have it as:
Sub AddHeader_CurrentSheet()
With ActiveSheet.PageSetup
.LeftHeader = Range(" 'Sheet1'!B14").Value
End With
End Sub
Here's the formatting "string" (I'm not a pro so pardon the loose language) I would like for above:
.LeftHeader = "&""-,Bold""&16&K0070C0 [NOTE: and then the cell referenced above would follow]
All help appreciated.
Bookmarks