This documentation is archived and is not being maintained.

Range.Delete Method 

Deletes the object.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

'Usage
Dim Shift As Object
Dim returnValue As Object
Dim range1 As Range
returnValue = range1.Delete(Shift)

object Delete(
	[In, Optional] object Shift
);
public System.Object Delete(
	/*in*/System.Object Shift
);
function Delete(
	 Shift : Object
) : Object;

Parameters

Shift

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.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Show: