# INSERTRANGE

#### 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

![](https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/VuiTM9xQmS3Eld9Nl1q7/grafik.png)