This documentation is archived and is not being maintained.
Range.ClearContents Method (Excel)
Clears the formulas from the range.
A variable that represents a Range object.
This example clears the formulas from cells A1:G37 on Sheet1 but leaves the formatting intact.