VBA Excel Help

[caritx]

I used the recorder in Excel 07 but when someone runs it in 03 this is failing. Can someone please help.

With Selection.Font
.Name = "Arial"
.FontStyle = "Bold"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
.TintAndShade = 0
.ThemeFont = xlThemeFontNone

Thanks a bunch!

 

[VoG]

Try

With Selection.Font
    .Name = "Arial"
    .Bold = True
    .Size = 10
    .ColorIndex = xlAutomatic
End With

 

[caritx]

Thanks!