Range.ClearContents (Excel)

Clears formulas and values from the range.

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