Export (0) Print
Expand All

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



Community Additions

ADD
Show:
© 2014 Microsoft