Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have problem similar to Sally's but I cannot find article to which you refer.
I've tried various combinations of the following but the subtotals "step on one another": Selection.Subtotal GroupBy:=3, _ Function:=xlSum, TotalList:=Array(16, 17, 18, 19, 20), _ Replace:=False, PageBreaks:=False, SummaryBelowData:=True Selection.Subtotal GroupBy:=2, _ Function:=xlSum, TotalList:=Array(16, 17, 18, 19, 20), _ Replace:=False, PageBreaks:=False, SummaryBelowData:=True Selection.Subtotal GroupBy:=1, _ Function:=xlSum, TotalList:=Array(16, 17, 18, 19, 20), _ Replace:=False, PageBreaks:=False, SummaryBelowData:=True Thank you for your contributions to this forum. George "Udo" wrote: Hi Sally, refer to the "article" VBA: Auto Grouping from May 2. in this forum. If this is not sufficient, write me, I'll give you then detailed support. Udo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro for group total | Excel Discussion (Misc queries) | |||
Group Total | Excel Discussion (Misc queries) | |||
Need to total how many came from a particular group. | Excel Discussion (Misc queries) | |||
Data Group Total | Excel Worksheet Functions | |||
Data Group Total | Excel Worksheet Functions |