Range.ClearContents Method (Excel)
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

Range.ClearContents Method (Excel)

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
Show:
© 2016 Microsoft