Expand Minimize

Range.Clear Method (Excel)

Clears the entire object.

expression .Clear

expression A variable that represents a Range object.

Return Value

Variant

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

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

Concepts

Other resources

Show:
© 2014 Microsoft