Please HELP!
No, but subtotal does perform many summary functions.
Regards,
Tom Ogilvy
LC wrote in message
...
In excel, the subtotal function ignores all other subtotal
functions.
Is there a way for the subtotal function to ignore other
function/formulas like sumproduct, sum, product, etc. ?
This is what I'm using:
Range(nrowcol).Activate
ActiveCell.Range(nrowcol).Select
Selection.subtotal GroupBy:=groups, Function:=xlSum, _
TotalList:=varr, Replace:=False, PageBreaks:=False, _
SummaryBelowData:=True
Thank you.
|