Hi s2h,

Do this:
Turn Macro Record On and then select a cell and format the text as you want and then turn the Macro Record Off. Look at the code that is recorded in VBA. Pick the parts of the .Font that you want/need. Here is what I get when I do this:
Sub Macro1()
' Macro1 Macro
'
    With Selection.Font
        .Name = "Calibri"
        .FontStyle = "Bold"
        .Size = 11
        .Strikethrough = False
        .Superscript = False
        .Subscript = False
        .OutlineFont = False
        .Shadow = False
        .Underline = xlUnderlineStyleNone
        .Color = 255
        .TintAndShade = 0
        .ThemeFont = xlThemeFontMinor
    End With
End Sub
You can learn a lot of VBA by simply recording a macro and see what VBA thinks you did.