Range.Clear Method (Excel)
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.
Worksheets("Sheet1").Range("A1:G37").Clear