Delete Method (IRange)

In This Topic

Delete a cell or a range of cells into the worksheet and shifts other cells.

Syntax

'Declaration
 
Sub Delete( _
   Optional ByVal shift As DeleteShiftDirection _
)

'Usage
 
Dim instance As IRange
Dim shift As DeleteShiftDirection
 
instance.Delete(shift)

void Delete( 
   DeleteShiftDirection shift
)

shift: A DeleteShiftDirection value indicates which way to shift the cells. If this argument is omitted, Spread decides based on the shape of the range.