Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can anyone help me understand the parameters of the
subtotal function ? For example, if in my code I want to do something like this: Worksheets("SubTotals").Range("D3: E900").Name = "MyRange" MyRange.Subtotal GroupBy:=2, Function:=xlSum, _ TotalList:=2, Replace:=True, _ PageBreaks:=False, SummaryBelowData:=False I'm OK with "Function", "Replace", "PageBreaks" and "SummaryBelowData", but what is GroupBy and TotalList ? What would the syntax be in this example ? Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subtotal Function | Excel Discussion (Misc queries) | |||
SubTotal Function | Excel Discussion (Misc queries) | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
Subtotal function (again) | Excel Worksheet Functions |