How to use cell value & format it in the header?

[UongSaki]

How do I get Excel to put the value in a cell (AA1) from all active worksheets into the header and format it to Arial, Bold 18 pts?


Private Sub Workbook_BeforePrint(Cancel As Boolean)

ActiveSheet.PageSetup.CenterHeader = ""

ActiveSheet.PageSetup.CenterHeader = "&""Arial,Bold""&18Value from cell AA1"

End Sub

Thanks you,

Saki

 

[xlhelp]

The place to ask this question is in Forum 707 :

http://www.tek-tips.com/threadminder.cfm?pid=707

But before you ask the question, it might be a really good idea to do a search in that forum.

Member- AAAA Association Against Acronym Abusers

 

[UongSaki]

Thank you for pointing me to the right Forum. I found it in thread707-935461.

Thanks,

Saki