I am running a report in Excel which makes use of the Subtotal function found under the Data menu in Excel. It takes the following arguements,
expression.Subtotal(GroupBy, Function, TotalList, Replace, PageBreaks, SummaryBelowData)
The problem I have is the TotalList arguement. When recording a macro (never the best thing) this arguement has the value Array(17, 61). As my report is dynamic I need to know what this Array is doing and I can make it relative.
Thanks for any help,