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.