H
hans
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
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