AddActiveCellRange(String,String,Boolean) Method

Adds a new cell range for the specified cell and makes it the active cell.

Syntax

Visual Basic

'Declaration
 
Public Overloads Function AddActiveCellRange( _
   ByVal rangeAddress As String, _
   ByVal activeCellAddress As String, _
   Optional ByVal extendRangeForMergedCells As Boolean _
) As Boolean

C#

public bool AddActiveCellRange( 
   string rangeAddress,
   string activeCellAddress,
   bool extendRangeForMergedCells
)

Parameters

rangeAddress

The new A1 address of the range to add

activeCellAddress

The A1 address of the new active cell for which a new selection will be added. This must be a cell within rangeAddress.

extendRangeForMergedCells

True to adjust the rangeAddress such that it contains any intersecting merged cells; otherwise false to use the range as it is.

Exceptions

Exception	Description
System.ArgumentException	The activeCellAddress must be within the specified rangeAddress.

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