SpreadsheetGear 2012
Delete(DeleteShiftDirection) Method






Specifies whether to shift cells left or up to relace the deleted cells.
Deletes cells, rows or columns, shifting remaining cells left or up and fixing up formulas.
Syntax
'Declaration
 
Overloads Sub Delete( _
   ByVal shiftDirection As DeleteShiftDirection _
) 
'Usage
 
Dim instance As IRange
Dim shiftDirection As DeleteShiftDirection
 
instance.Delete(shiftDirection)
procedure Delete( 
    shiftDirection: DeleteShiftDirection
); 
function Delete( 
   shiftDirection : DeleteShiftDirection
);

Parameters

shiftDirection
Specifies whether to shift cells left or up to relace the deleted cells.
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

IRange Interface
IRange Members
Overload List
DeleteShiftDirection Enumeration
Delete Method
Insert Method
Insert(InsertShiftDirection) Method

Send Feedback