Range.ClearContents Method

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  Worksheets("Sheet1").Range("A1:G37").ClearContents

See Also