Share via


Range.Delete Method

Excel Developer Reference

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

See Also