Version

Add(String,CellReferenceMode) Method

Adds a list of references to the collection of references.
Syntax
'Declaration
 
Public Overloads Sub Add( _
   ByVal references As String, _
   ByVal cellReferenceMode As CellReferenceMode _
) 
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
ExceptionDescription
System.ArgumentNullExceptionOccurs when the references is null.
System.ComponentModel.InvalidEnumArgumentExceptionOccurs 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

See Also