RANGE
Returns a part of a range.
Syntax
RANGE(range; rowStart; columnStart; rowEnd; columnEnd)
range - a range of values - Value type: range
rowStart - the row index of the upper left cell of the subrange - Value type: integer
columnStart - the column index of the upper left cell of the subrange - Value type: integer
rowEnd - the row index of the lower right cell of the subrange - Value type: integer
columnEnd - the column index of the lower right cell of the subrange - Value type: integer
Remarks
rowEnd and columnEnd could contain the text "last". In this case, all rows / columns until the end of the range are returned.
