Removes all of the data, formatting, formulas, and notes from a range of cells on this sheet.
Syntax
Visual Basic (Usage) | Copy Code |
---|
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) |
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
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also