Add(String,CellReferenceMode) Method

Adds a list of references to the collection of references.

Syntax

Visual Basic

'Declaration
 
Public Overloads Sub Add( _
   ByVal references As String, _
   ByVal cellReferenceMode As CellReferenceMode _
) 

C#

public void Add( 
   string references,
   CellReferenceMode cellReferenceMode
)

Parameters

references

The space delimited list of references to add to the collection.

cellReferenceMode

The cell reference mode with which to parse the references.

Exceptions

Exception	Description
System.ArgumentNullException	Occurs when the references is null.
System.ComponentModel.InvalidEnumArgumentException	Occurs when cellReferenceMode is not defined in the CellReferenceMode enumeration.
System.ArgumentException	Occurs when the list of reference is not well formed.

Remarks

The references must be separated by one or more space (' ') characters.

The references in the list cannot contain the worksheet name. They are all assumed to be from the worksheet of this collection.

If all references are already contained in the collection this call will have no effect on the collection.

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