Clear Method (IRange)

In This Topic

Removes all the data and formulas from the specified range of cells.

Syntax

'Declaration
 
Function Clear( _
   Optional ByVal options As ManipulationOptions _
) As Boolean

'Usage
 
Dim instance As IRange
Dim options As ManipulationOptions
Dim value As Boolean
 
value = instance.Clear(options)

bool Clear( 
   ManipulationOptions options
)

options: The options indicates which data type will be performed. If this argument is omitted, all data will be clear.