Export (0) Print
Expand All

Range.RemoveSubtotal Method

Office 2007
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.

Visual Basic for Applications
Worksheets("Sheet1").Range("A1:G37").RemoveSubtotal



Community Additions

ADD
Show:
© 2014 Microsoft