Version

DeleteCells(String,Boolean) Method

Deletes a region of cells.
Syntax
'Declaration
 
Public Overloads Sub DeleteCells( _
   ByVal address As String, _
   ByVal shiftCellsLeft As Boolean _
) 
public void DeleteCells( 
   string address,
   bool shiftCellsLeft
)

Parameters

address
The address of the region to delete
shiftCellsLeft
If true will shift cells left from the right of the region to occupy the deleted region, otherwise will shift cells up from below the region.
Exceptions
ExceptionDescription
System.InvalidOperationExceptionIf the operation is not allowed, e.g. if it the range intersects with a protected region.
System.ArgumentExceptionIf address is not valid.
Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, 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