DeleteCells(String,Boolean) Method

Deletes a region of cells.

Syntax

Visual Basic

'Declaration
 
Public Overloads Sub DeleteCells( _
   ByVal address As String, _
   ByVal shiftCellsLeft As Boolean _
) 

C#

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

Exception	Description
System.InvalidOperationException	If the operation is not allowed, e.g. if it the range intersects with a protected region.
System.ArgumentException	If address is not valid.

Requirements

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