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

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;



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