This documentation is archived and is not being maintained.

Range.Delete Method

Office 2007
Deletes the object.

Syntax

expression.Delete(Shift)

expression   A variable that represents a Range object.

Parameters

NameRequired/OptionalData TypeDescription
ShiftOptionalVariantUsed 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




Show: