DeleteCells(WorksheetRegion,Boolean) Method

Deletes a region of cells.

Syntax

Visual Basic

'Declaration
 
Public Overloads Sub DeleteCells( _
   ByVal region As WorksheetRegion, _
   ByVal shiftCellsLeft As Boolean _
) 

C#

public void DeleteCells( 
   WorksheetRegion region,
   bool shiftCellsLeft
)

Parameters

region

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.ArgumentNullException	If region is null.

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