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.
