Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Font Size in Excel
Message
From
22/05/2002 06:36:12
 
 
To
22/05/2002 06:28:43
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00659796
Message ID:
00659799
Views:
30
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform