RemoveSubtotal Method

Applies To

Range Object.

Description

Removes subtotals from a list.

Syntax

object.RemoveSubtotal

object

Required. The Range object.

See Also

Subtotal Method.

Example

This example removes subtotals for the range A1:G37 on Sheet1. The example should be run on a list that has subtotals.

Worksheets("Sheet1").Range("A1:G37").RemoveSubtotal