8c957fdd-e99d-ca0e-7d2c-4cb1db62639a.md

Range.ClearContents Method (Excel)

Clears the formulas from the range.

Syntax

expression . ClearContents

expression A variable that represents a Range object.

Return Value

Variant

Example

This example clears the formulas from cells A1:G37 on Sheet1 but leaves the formatting intact.

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

See also

Concepts

Range Object

Other resources

Range Object Members