Range.RemoveSubtotal Method (Excel)

Removes subtotals from a list.

Syntax

expression. RemoveSubtotal

expression A variable that represents a [Range](Excel.Range(Graph property).md) 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

See also

Range Object