Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
subtotal question
I use the following vba code
Cells.Select Selection.Subtotal GroupBy:=6, Function:=xlSum, TotalList:=Array(4, 5), _ Replace:=True, PageBreaks:=False, SummaryBelowData:=True Selection.Subtotal GroupBy:=7, Function:=xlSum, TotalList:=Array(4, 5), _ Replace:=False, PageBreaks:=False, SummaryBelowData:=True The touble is that the TOTAL and SUBTOTAL apear in the row f and g I would like them to to apear in row a is there a trick? greetings hans |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal question | Excel Worksheet Functions | |||
subtotal question? | Excel Worksheet Functions | |||
subtotal question | Excel Discussion (Misc queries) | |||
Subtotal Question | Excel Worksheet Functions | |||
Subtotal question | Excel Worksheet Functions |