Deletes the object.
Syntax
expression.Delete (Shift)
expression A variable that represents a Range object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Shift | Optional | Variant | Used only with Range objects. Specifies how to shift cells to replace deleted cells.
Can be one of the following XlDeleteShiftDirection constants: xlShiftToLeft or xlShiftUp. If this argument is omitted, Microsoft Excel decides based on the shape of the range. |
Return value
Variant
Examples
The following example deletes the third entire row.
Rows(3).Delete