Sub totalling in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to replicate the subtotaling Excel does in >Data>Subtotals
using VBA? I don't need the 3 worksheets layout, just a single worksheet
sorted by (say)column A then and subtotalling selected columns after each of
record in column A.
Any ideas gratefully recieved.
Thanks
 
Turn on the macro recorder when you sort your data, then apply data|subtotals.

But I'm not sure what the "3 worksheets layout" is.
 
Back
Top