How to get Bold, Italicized header

[davidam]

Hello All,
This works fine to give me a bolded header:

        With mySheet.PageSetup
            .LeftHeader = "&""Arial,Bold""&12" & headString
        End with

Where headString is a string variable. I can change the word 'Bold' to 'Italic' and then I get an unbolded, italicized header. But everything I try to inlcude both fails. Any ideas?
Thanks,
Dave

 

[JoeMo]

Have you tried "Arial, Bold Italic" or "Arial, BoldItalic"?

 

[JLGWhiz]

Hello All,
This works fine to give me a bolded header:

        With mySheet.PageSetup
            .LeftHeader = "&""Arial,Bold""&12" & headString
        End with

Where headString is a string variable. I can change the word 'Bold' to 'Italic' and then I get an unbolded, italicized header. But everything I try to inlcude both fails. Any ideas?
Thanks,
Dave

Ttry this syntax

Sub t()
ActiveSheet.PageSetup.LeftHeader = "&I &B &12 &Arial" & headString
End Sub

 

[davidam]

Suggestion from JoeMo: "Arial, Bold Italic" and suggestion from JLGWhiz: "&I &B &12 &Arial" Both work!!
Many Thanks,
Dave

 

[JLGWhiz]

Suggestion from JoeMo: "Arial, Bold Italic" and suggestion from JLGWhiz: "&I &B &12 &Arial" Both work!!
Many Thanks,
Dave

Happy to assist,
Regards, JLG