Hiya, i know i may be on a 'i need help' spree but i hope this is the last one for today =P
i got this code here for subtotals:
what i want to be able to do is... instead of the results displaying in array 6 (column F) i want them to display in column G while still summing up column F. Is this at all possible? Column G is blank with a title, but it's where the subtotals are meant to show. At the moment when the subtotals is done, i have to stop the macro so that the user cuts and pastes the subtotals from F to G.
Thanks
i got this code here for subtotals:
Code:
Selection.Subtotal GroupBy:=2, Function:=xlSum, TotalList:=Array(6), _
Replace:=True, PageBreaks:=False, SummaryBelowData:=True
what i want to be able to do is... instead of the results displaying in array 6 (column F) i want them to display in column G while still summing up column F. Is this at all possible? Column G is blank with a title, but it's where the subtotals are meant to show. At the moment when the subtotals is done, i have to stop the macro so that the user cuts and pastes the subtotals from F to G.
Thanks
Last edited: