# 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://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-c62e1ec833ca61b1c04b28b51e1466e4821a853b%2Fgrafik.png?alt=media)