Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Autofill a formula in Excel
Message
 
To
21/12/1999 13:25:15
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00306668
Message ID:
00307185
Views:
32
I have worked this one out.
You have to pass a range then autofill from the range.

ox.Cells(435,4).Value = '=IF(ISNA(MATCH($A$69,E71:E435,0))=TRUE,0,MATCH($A$69,E71:E435,0))'
WITH ox.activeworkbook.worksheets(1)
.Range("D435").AutoFill(.Range("D435:AY435"),0) && 0 = xlFillDefault
ENDWITH

Hopefully this might be of some use to others.

Martin
If only everything in life was as reliable as VFP
Previous
Reply
Map
View

Click here to load this message in the networking platform