Ordinal Property (Cell)

Uniquely identifies a cell by its position within a cellset.

Return Values

Returns a Long integer and is read-only.

Remarks

The cell's ordinal value uniquely identifies the cell within a 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 numbered starting from zero in row-major order. Here is the formula for calculating the ordinal number of a cell:

The cell's ordinal value can be used with the Item property of the Cellset object to quickly retrieve the Cell.

See Also

VBScript Example

Cellset Object | Item Property (Cellset) | Ordinal Property (Position)

Applies To: Cell Object