subtotal question



I use the following vba code
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



Tom Ogilvy

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotal Formatting 2
Subtotal by VBA 5
Subtotals 2
Issue with nested data subtotals 3
Subtotal function 2
strange problem subtotal 1
Excel Subtotals 2
Toggle Subtotal on and off 2