Range.Delete Method (Excel)
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