Hi All,
I have a small problem using the Excel Subtotal command. It works fine as long as the SUM is for a single column, but how do I pass an "Array" to allow for more than one column.
VBA Macro Code:
Selection.Subtotal GroupBy:=7, Function:=xlSum, TotalList:=Array(24, 31), _
Replace:=True, PageBreaks:=False, SummaryBelowData:=True
Foxpro Code:
xl.selection.subtotal('7',-4157,'24',.f.,.f.,.t.)
This works fine for column 24, but I have tried various combinations to pass both column 24 and column 31.
Does anyone have the correct syntax please.