J
Josh Sale
I have a worksheet with a data list that uses Subtotals
which I programatically create but that users sometimes
modify (e.g., they change page break before or display
totals above instead of below).
Under certain circumstances I need to remove the
Subtotals, do some processing and then put back the
Subtotals.
I've searched around in the Excel object model looking for
the representation of an active Subtotal but not found
anything. Is the definition of an existing Subtotal
available to VBA? If so, I'll save away all of the
current settings, remove the existing subtotals, do my
processing and then reinstate the Subtotals as they were
before I removed them.
TIA,
josh
which I programatically create but that users sometimes
modify (e.g., they change page break before or display
totals above instead of below).
Under certain circumstances I need to remove the
Subtotals, do some processing and then put back the
Subtotals.
I've searched around in the Excel object model looking for
the representation of an active Subtotal but not found
anything. Is the definition of an existing Subtotal
available to VBA? If so, I'll save away all of the
current settings, remove the existing subtotals, do my
processing and then reinstate the Subtotals as they were
before I removed them.
TIA,
josh