Hey everyone,
I have a macro that contains a series of subtotaling based on criteria, and it seems to add the most time to the entire macro to execute. It is a decent set of data, 500-700 rows at a time, and subtotaling several things in succession. Is there a command to do it faster than the method used currently? Is there a more efficient command to replicate this? Does subtotaling get time consuming on macros?
I have calculation to manual, screen updating off etc before this kicks in so it should help as well.
Columns("B:N").Select
Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(12, 13), _
Replace:=False, PageBreaks:=False, SummaryBelowData:=True
I have a macro that contains a series of subtotaling based on criteria, and it seems to add the most time to the entire macro to execute. It is a decent set of data, 500-700 rows at a time, and subtotaling several things in succession. Is there a command to do it faster than the method used currently? Is there a more efficient command to replicate this? Does subtotaling get time consuming on macros?
I have calculation to manual, screen updating off etc before this kicks in so it should help as well.
Columns("B:N").Select
Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(12, 13), _
Replace:=False, PageBreaks:=False, SummaryBelowData:=True