ClearRange(Int32,Int32,Int32,Int32,Boolean,ClipboardCopyOptions) Method
Removes all of the data, formatting, formulas, and notes from a range of cells on this sheet.
'Declaration
Public Overloads Sub ClearRange( _
ByVal As Integer, _
ByVal column As Integer, _
ByVal As Integer, _
ByVal columnCount As Integer, _
ByVal As Boolean, _
ByVal As ClipboardCopyOptions _
)
'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
Dim copyOptions As ClipboardCopyOptions
instance.ClearRange(row, column, rowCount, columnCount, dataOnly, copyOptions)
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
- copyOptions
- ClipboardCopyOptions