Range.Item[Object, Object] Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Returns a Range object that represents a range at an offset to the specified range.

public:
 property System::Object ^ Item[System::Object ^, System::Object ^] { System::Object ^ get(System::Object ^ RowIndex, System::Object ^ ColumnIndex); void set(System::Object ^ RowIndex, System::Object ^ ColumnIndex, System::Object ^ value); };

public object Item[object RowIndex, object ColumnIndex] { get; set; }

Public Property Item(RowIndex As Object, Optional ColumnIndex As Object) As Object

Parameters

RowIndex: Object

Required Object. The index number of the cell you want to access, in order from left to right, then down. Range.Item(1) returns the upper-left cell in the range; Range.Item(2) returns the cell immediately to the right of the upper-left cell.

ColumnIndex: Object

Optional Object. A number or string that indicates the column number of the cell you want to access, starting with either 1 or "A" for the first column in the range.

Property Value

Object

Remarks

The RowIndex and ColumnIndex arguments are relative offsets. In other words, specifying a RowIndex of 1 returns cells in the first row of the range, not the first row of the worksheet.

Applies to