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 |
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 |
All times are GMT +1. The time now is 10:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com