Range.ClearContents Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Clears the formulas from the range.

expression .ClearContents

expression A variable that represents a Range object.

Return Value

Variant

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

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

Concepts

Other resources

Show: