ROWTORANGE

Converts the cells of a row into a range.

Syntax

RANGETOROW(row; numColumns)

• row - the row which should be converted to a range - Value type: row with cells of any value type

• numColumns - the number of columns of the return range - Value type: number

Remarks

1. The function returns a range with

   1. numColumns as number of columns

   2. as many rows so that all cells of row are included

   3. the cells of row are added row-wise, from in the order from top left to bottom right

   4. the cells have the same value and value type as the according cells of row

Example

Here, the widget wine list row is converted to a range with an appropriate number of columns (5 in this case):