Bold Header - VBA

[Pascal]

Hi,

I've tried the following to make my Center Header bold, but all I get is a 't' displayed on the first line?

'* Setup for Printing.
    With Worksheets("Sheet1")
        .PageSetup.PrintArea = "$A$10:$G$" & lngPos + lngRecNum & ""
        .PageSetup.Orientation = xlLandscape
        .PageSetup.CenterHorizontally = True
        .PageSetup.CenterHeader = "&""Tahoma,Bold" & ActiveSheet.Cells(1, 1).Value & Chr(13) & Chr(13) & "Week Commencing " & Format(dteDate, "dddd dd mmm yyyy")
    End With

I really just want the first line to be in bold.

Thanks & Regards

 

[VoG]

Maybe

.PageSetup.CenterHeader = "&""Tahoma,Bold""&11" & ActiveSheet.Cells(1, 1).Value & Chr(13) & Chr(13) & "Week Commencing " & Format(dteDate, "dddd dd mmm yyyy")

 

[Pascal]

Many thanks...

That does make the header bold, but how can I just make my first line in the header bold?

Regards