Removes subtotals from a list.
Syntax
expression.RemoveSubtotal
expression A variable that represents a Range object.
Return value
Variant
Example
This example removes subtotals from the range A1:G37 on Sheet1. The example should be run on a list that has subtotals.
Worksheets("Sheet1").Range("A1:G37").RemoveSubtotal