Sub totalling in VBA
 

Is it possible to replicate the subtotaling Excel does in DataSubtotals
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
--
Peter
London, UK

Sub totalling in VBA
 

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.

Peter wrote:

Is it possible to replicate the subtotaling Excel does in DataSubtotals
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
--
Peter
London, UK

--

Dave Peterson