J
Josh Sale
I have a worksheet with a data list that uses Subtotals which I
programmatically create but that users sometimes modify (e.g., they change
the page break before and after).
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
programmatically create but that users sometimes modify (e.g., they change
the page break before and after).
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