CELL

Returns a cell of a range.

Syntax

CELL(range; rowIndex; columnIndex)

• range - a range of values - Value type: range

• rowIndex - the index of the row of the cell to return - Value type: integer (optional, default value: 1)

• columnIndex - the index of the column of the cell to return - Value type: integer (optional, default value: 1)

Remarks

• The function can either be called with 1 or 3 parameters.

• rowIndex and/or columnIndex can contain the text “last”. In this case, the last row or the last column of range is used as index.

Example