Excel.Range.ClearFormats.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Range.ClearFormats method (Excel)	vbaxl10.chm144096	vbaxl10.chm144096	Excel.Range.ClearFormats	37777379-857a-f4c7-86aa-b109d5f25757	05/10/2019	medium

Range.ClearFormats method (Excel)

Clears the formatting of the object.

Syntax

expression.ClearFormats

expression A variable that represents a Range object.

Return value

Variant

Example

This example clears all formatting from cells A1:G37 on Sheet1.

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

This example clears the formatting from embedded chart one on Sheet1.

Worksheets("Sheet1").ChartObjects(1).Chart.ChartArea.ClearFormats

[!includeSupport and feedback]