Would anyone know if after asking Excel to provide subtotals you can get a reference to the subtotals? I see a “get subtotals” command in the excel scriptng reference but can’t find a way to apply it to what I am doing. I need to process a series of .xls files and get subtotals for various groupings out of each file, then make a row of subtotal results.
I haven’t used these features, but I notice that Get Subtotal and Set Subtotal relate to pivot tables, while Remove Subtotals and Subtotals relate to ranges.
Thanks, Mike.
How would you use Subtotals?
It doesnt seem to like:
tell range "A2:A5" subtotals end tell