Range.ClearContents Method
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 |
|---|
|