Static
$tStatic
nextGets the number of cells contains in all references in this collection.
Adds a region to the collection of references.
The region added to the collection must be from the same worksheet as the collection.
If the region is already contained in the collection, or there is a region in the collection which fully contains the specified region, this call will have no effect on the collection.
ArgumentNullException Occurs when the 'region' is null.
ArgumentException Occurs when the 'region' is from a Worksheet other than the references collection.
The region to add to the collection.
Adds a cell to the collection of references.
The cell added to the collection must be from the same worksheet as the collection.
If the cell is already contained in the collection, or there is a region in the collection which contains the cell, this call will have no effect on the collection.
ArgumentNullException Occurs when the 'cell' is null.
ArgumentException Occurs when the 'cell' is from a Worksheet other than the references collection.
The cell to add to the collection.
Adds a list of references to the collection of references.
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.
ArgumentNullException Occurs when the 'references' is null.
ArgumentException Occurs when the list of reference is not well formed.
The space delimited list of references to add to the collection.
Adds a list of references to the collection of references.
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.
ArgumentNullException Occurs when the 'references' is null.
InvalidEnumArgumentException Occurs when 'cellReferenceMode' is not defined in the CellReferenceMode enumeration.
ArgumentException Occurs when the list of reference is not well formed.
The space delimited list of references to add to the collection.
The cell reference mode with which to parse the 'references'.
Determines whether the collection contains the specified region.
ArgumentNullException Occurs when the 'region' is null.
True if the region is contained in the collection or a region which fully contains the specified region is contained in the collection; False otherwise.
The region to search for in the collection.
Determines whether the collection contains the specified cell.
ArgumentNullException Occurs when the 'cell' is null.
True if the cell is contained in the collection or a region which contains the cell is contained in the collection; False otherwise.
The cell to search for in the collection.
Removes a region from the collection of references.
If the region is not contained in the collection, this call will have no effect on the collection.
ArgumentNullException Occurs when the 'region' is null.
True if any cells in the region were found and removed. False otherwise.
The region to remove from the collection.
Removes a cell from the collection of references.
If the cell is not contained in the collection, this call will have no effect on the collection.
ArgumentNullException Occurs when the 'cell' is null.
True if the cell was found and removed. False otherwise.
The cell to remove from the collection.
Removes a list of references from the collection of references.
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.
ArgumentNullException Occurs when the 'references' is null.
ArgumentException Occurs when the list of reference is not well formed.
True if any cells in the references were found and removed. False otherwise.
The space delimited list of references to remove from the collection.
Removes a list of references from the collection of references.
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.
ArgumentNullException Occurs when the 'references' is null.
InvalidEnumArgumentException Occurs when 'cellReferenceMode' is not defined in the CellReferenceMode enumeration.
ArgumentException Occurs when the list of reference is not well formed.
True if any cells in the references were found and removed. False otherwise.
The space delimited list of references to remove from the collection.
The cell reference mode with which to parse the 'references'.
Returns the string value represent the cell and region addresses in the collection.
Returns the string value represent the cell and region addresses in the collection.
InvalidEnumArgumentException Occurs when 'cellReferenceMode' is not defined in the CellReferenceMode enumeration.
The cell reference mode with which to get the region strings.
Static
compareStatic
compareStatic
equalsStatic
equalsStatic
getStatic
getStatic
getStatic
reference
A collection of cells or regions which are all on the same worksheet.