Hi everyone,

I have found great answers that come close to answering the question I have, but because I know nothing about VB, I don't know how to adapt those answers to get the exact solution I need. Here it is:

Using Excel 2007, I am using a piece of code I found online to use a cell reference to populate the left header of my worksheet. The code is below. It works great. However I need the resulting text to be formatted in a particular way. The formatting I need is:

Arial
size 12
bold
RGB colors: 0,51,102

So, how does the code below need to look to incorporate these specifications? If someone could rewrite it for me, I will be hugely grateful.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader = ActiveSheet.Cells(4, 1)
End Sub

Thanks in advance,
Frank