Item Property
Returns a Range object that represents a range that's offset from the specified range. Read/write Variant.
expression.Item(RowIndex, ColumnIndex)
expression Required. An expression that returns one of the objects in the Applies To list.
RowIndex Optional Variant. The row number of the cell you want to work with (the first row in the range is 1).
ColumnIndex Optional Variant. A number or string that indicates the column number of the cell you want to work with (the first column in the range is either 1 or A).
Remarks
Syntax 1 uses a row number and either a column number or a letter as index arguments. For more information about this syntax, see the Range object. The RowIndex and ColumnIndex arguments are relative offsets. In other words, specifying 1 for RowIndex returns cells in the first row in the range, not the first row on the datasheet.
Example
This example clears cell B2 on the datasheet.
myChart.Application.DataSheet.Range("A1").Item(2, 2).Clear