Remove(String,CellReferenceMode) Method

Removes a list of references from the collection of references.

Syntax

Visual Basic

'Declaration
 
Public Overloads Function Remove( _
   ByVal references As String, _
   ByVal cellReferenceMode As CellReferenceMode _
) As Boolean

C#

public bool Remove( 
   string references,
   CellReferenceMode cellReferenceMode
)

Parameters

references

The space delimited list of references to remove from the collection.

cellReferenceMode

The cell reference mode with which to parse the references.

Return Value

True if any cells in the references were found and removed. False otherwise.

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 the references are not 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