The Item method retrieves a Cell from a Cellset using its coordinates.
Syntax
Set Cell = Cellset.Item ( Positions )
Parameters
Positions Variant Array of values that uniquely specify a Cell. Positions can be one of the following:
Remarks
Use the Item method to return a Cell within the Cellset. If the Item method cannot find the cell corresponding to the Positions argument, an error occurs.
The Item method is the default method for the Cellset object. The following syntax forms are interchangeable:
Cellset.Item ( Positions )
Cellset ( Positions )
The Positions argument is used to specify which cell to return. You can specify the cell by ordinal position or by the position along each axis. When specifying the cell by position along each axis, you can specify the numeric value of the position or the names of the members for each position.
The ordinal position is a number that uniquely identifies one cell within the Cellset. Conceptually, cells are numbered in a Cellset as if the Cellset were a p-dimensional array, where p is the number of axes. Cells are addressed in row-major order. Below is the formula for calculating the ordinal number of a cell:
If member names are passed as strings to Item, the members must be listed in increasing order of the numeric axis identifiers. Within an axis, the members must be listed in increasing order of dimension nesting—that is, the outermost dimension’s member comes first, followed by members of inner dimensions. Each dimension should be represented by a separate string, and the list of member strings should be separated by commas.