Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.SubTotal: Controlling where the caption goes?
Something like this:
Selection.Subtotal GroupBy:=4, Function:=xlSum, TotalList:=Array(9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28), Replace:=True, PageBreaks:=False, SummaryBelowData:=True gives me what I want except for the location of the "...Total" lab el - which defaults to the column being totalled. What the user wants is for all the "...Total" labels (where will be up to 3 levels of subtotals) to appear in column 1. Is there a way? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal To Include Item Description On Subtotal Line | Excel Discussion (Misc queries) | |||
Display a Line w/ Caption instead of Frame w/ Caption | Excel Programming | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
How to reference win.caption, when caption changes | Excel Programming | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |