Ger,
I think it should be ExcelApp.Selection.Font.Size = 8
HTH
>
>I want to modify the Font Style and Font Size of some cells in excel.
>The following lines of code work ok for FontStyle but not for FontSize.
>
>ExcelApp.Worksheets("SHEET1").Range("G6:G16").Select
>ExcelApp.Selection.Font.FontStyle = "Bold"
>ExcelApp.Selection.Font.FontSize = 8
>
>Am I using the wrong property?
>
>
>Thanking you in advance,
>
>Ger
Daniel