Range.Delete Method

  • Article

Deletes the object.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function Delete ( _
    Shift As Object _
) As Object
'Usage
Dim instance As Range
Dim Shift As Object
Dim returnValue As Object

returnValue = instance.Delete(Shift)

Object Delete(
    Object Shift
)

Parameters

  • Shift
    Type: System.Object

    Optional Object. 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

Type: System.Object

See Also

Reference

Range Interface

Range Members

Microsoft.Office.Interop.Excel Namespace