At Method

See Also Applies To Example Model

Returns a Cell at a specifies row-column location if the Cells collection.

object expression.At (RowIndex, ColumnIndex)

object expression    Required. An object expression that evaluates to an object in the Applies To list.

RowIndex    Required Long. The ordinal row index (integer) of the object to be returned.

ColumnIndex    Required Long. The ordinal column index (integer) of the object to be returned.

Remarks

The At method is the default property for the Cells collection object if two parameters (RowIndex and ColumnIndex) are supplied. If only one parameter is supplied, then the default property is the Item method.

Example

The following examples show equivalent syntax for setting the color of the Cell in the row 3 and column 2 of the Cells collection grid.

Cells.At(3, 2).Color=vbtBlue

Cells.(3, 2).Color=vbtBlue