This documentation is archived and is not being maintained.

Range.ClearContents Method

Office 2007
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



Show: