Export (0) Print
Expand All

Range.Clear Method

Office 2007
Clears the entire object.

Syntax

expression.Clear

expression   A variable that represents a Range object.

Return Value
Variant

Example
This example clears the formulas and formatting in cells A1:G37 on Sheet1.

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



Community Additions

ADD
Show:
© 2015 Microsoft