Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Autofill a formula in Excel
Message
 
À
21/12/1999 13:25:15
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00306668
Message ID:
00307185
Vues:
30
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform