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.

Examples