In This Topic
Removes all of the data, formatting, formulas, and notes from a range of cells on this sheet.
Syntax
'Declaration
Public Sub ClearRange( _
ByVal As Integer, _
ByVal column As Integer, _
ByVal As Integer, _
ByVal columnCount As Integer, _
ByVal As Boolean _
)
'Usage
Dim instance As SheetView
Dim row As Integer
Dim column As Integer
Dim rowCount As Integer
Dim columnCount As Integer
Dim dataOnly As Boolean
instance.ClearRange(row, column, rowCount, columnCount, dataOnly)
public void ClearRange(
int ,
int column,
int ,
int columnCount,
bool
)
Parameters
- row
- Row index of first cell in range
- column
- Column index of first cell in range
- rowCount
- Number of rows in range
- columnCount
- Number of columns in range
- dataOnly
- Whether to remove only data
Example
This example uses the ClearRange method.
See Also