Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel.subtotal
Message
From
14/08/2002 14:42:39
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Excel.subtotal
Miscellaneous
Thread ID:
00689689
Message ID:
00689689
Views:
60
the following reports oRange is not an object


oRange=THISFORM.oExcel.activesheet.RANGE("a4:l"+TRANSFORM(lnNumRecs))

oRange.selection.Subtotal(1,-4157,la1,.t.,.f.,.t.)



It is supposed to subtotal on theleftmost column. la1 is an array with 5 members each being the column number of the5 colums which need to be subtotaled

Anyone any ideas??

Thanks
Peter
Peter Cortiel
Next
Reply
Map
View

Click here to load this message in the networking platform