Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotal formats
Hi
what I have is this: *num is a variable for where the column of the array should start.. Dim varr() Dim rng As Range, i As Long Set rng = Range("IV1").End(xlToLeft) ReDim varr(1 To rng.Column - num) For i = 1 To rng.Column - num varr(i) = i + num Next ActiveCell.Range("A3").Select Selection.subtotal GroupBy:=groups, Function:=xlSum, _ TotalList:=varr, Replace:=False, PageBreaks:=False, _ SummaryBelowData:=True Questions: Can I write the above subtotal function in a different format? and Can I disable the grand total summary from the subtotal function If you could help me with that, that would be wonderful. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal To Include Item Description On Subtotal Line | Excel Discussion (Misc queries) | |||
sort macro, subtotal and add lines after subtotal | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |