Excel.Range.ClearContents.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Range.ClearContents method (Excel)	vbaxl10.chm144095	vbaxl10.chm144095	Excel.Range.ClearContents	8c957fdd-e99d-ca0e-7d2c-4cb1db62639a	05/10/2019	high

Range.ClearContents method (Excel)

Clears formulas and values from the range.

Syntax

expression.ClearContents

expression A variable that represents a Range object.

Return value

Variant

Example

This example clears formulas and values from cells A1:G37 on Sheet1, but leaves the cell formatting and conditional formatting intact.

Worksheets("Sheet1").Range("A1:G37").ClearContents

[!includeSupport and feedback]