Share via

Range.ClearContents Method

  • Article

Clears the formulas from the range.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function ClearContents As Object
'Usage
Dim instance As Range
Dim returnValue As Object

returnValue = instance.ClearContents()

Object ClearContents()

Return Value

Type: System.Object

Remarks

This method clears the data from a chart but leaves the formatting.

See Also

Reference

Range Interface

Range Members

Microsoft.Office.Interop.Excel Namespace