Nested Subtotal Process

[daveonion]

Hi all
I'm currently using the subtotal function within a macro, however i need it to be nested, i.e. include another grouping of fields and give subtotals for each nested group.
I've looked in excel and it shows how to do nested subtotals however i have no idea how to do it within VBA,
MANY THANKS FOR ANY HELP

 

[SkipVought]

Hi,

Do you want to use the SUBTOTAL function with nested subtotals? If so, just record what you are doing on the spreadsheet. What the SUBTOTAL function does is NOT to double-dip on the desired arithmetic opperation.

If you want to control subtotaling within your procedure, you will have to keep track of the break points and use a multi-dimensional array as one possibility.

Hope this helps

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[daveonion]

thanks skipvought