INSERTRANGE

Returns a range where another range has been inserted.

Syntax

INSERTRANGE(range; insertRange; row; column)

• range - the range in which insertRange should be inserted - Value type: range

• insertRange - the range which should be inserted into range - Value type: range

• row - the row position of range, where insertRange should be inserted - Value type: number

• column - the column position of range, where insertRange should be inserted - Value type: number

The function returns a new range, containing

• range, starting at position (1, 1)

• insertRange, starting at position (row, column) and replacing the values of range there

Examples