Delete Method
TOC
Collapse the table of content
Expand the table of content

Range.Delete Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Deletes the object.

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

Concepts

Other resources

Show:
© 2016 Microsoft