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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
subtotal question
Not in the settings for subtotal. You would need to include code in your
macro to move them from COLUMN F and G and place them in COLUMN A. -- Regards, Tom Ogilvy "hans" wrote in message ... 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 |
Reply |
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 |