DeleteRange

Delete cells from one or all sheets.

The following overloads are available:

Overload Name Description
General Delete cells.

General

Delete cells.

Argument Description
SpecifySheetBy Select how to specify which worksheet to select while the method is being executed.
This option is limited one of the following values: <blank> SheetName SheetNumber AllSheets
SheetSpec Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty.
Address The address of a range to select for the execution of the method.
CellByCell Whether to execute the method on a cell-by-cell basis, or on the range specified by the address.
ReverseOrder Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true.
MethodCondition If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value: <blank> FALSE TRUE
CellCondition If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value: <blank> FALSE TRUE
DeleteRange The address of the cells to delete.
ShiftDirection The shift mode for the delete.
This option is limited one of the following values: <blank> ShiftLeft ShiftUp ShiftEntireRow ShiftEntireColumn