Skip to content

Latest commit

 

History

History
40 lines (24 loc) · 750 Bytes

Excel.Range.RemoveSubtotal.md

File metadata and controls

40 lines (24 loc) · 750 Bytes
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Range.RemoveSubtotal method (Excel)
vbaxl10.chm144185
vbaxl10.chm144185
Excel.Range.RemoveSubtotal
ec1fd131-551d-009f-1eea-033d805bb34d
05/11/2019
medium

Range.RemoveSubtotal method (Excel)

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

[!includeSupport and feedback]