Clears formulas and values from the range.
Syntax
expression.ClearContents
expression A variable that represents a Range object.
Return value
Variant
Example
This example clears formulas and values from cells A1:G20 on Sheet1, but leaves the cell formatting and conditional formatting intact.
Worksheets("Sheet1").Range("A1:G20").ClearContents