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.
 

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

Help! Subtotal using formulas or VBA 5
Auto filter, sub totals, text 4
AutoFilter and Sub-total 6
Quick/efficient way to VBA subtotal 2
Calculating subtotals 22
Subtotal GroupBy text string 2
Subtotal Formatting 2
Subtotals with variable total/sum location 2

Back
Top