CellRange Command

CellRange( <Start Cell>, <End Cell> )

Creates a list containing the cell values in this cell range.

Let A1 = 1, A2 = 4, A3 = 9 be spreadsheet cells values.Then CellRange(A1, A3) returns the list {1, 4, 9}.

A1:A3 is a shorter syntax.