Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please HELP!
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|