# RANGE

#### Syntax <a href="#syntax.40" id="syntax.40"></a>

**RANGE**(*range;* *rowStart;* *columnStart;* *rowEnd;* *columnEnd*)

* *range* - a range of values *- **Value type**: range*
* *rowStart* - the row index of the upper left cell of the subrange *- **Value type**: integer*
* *columnStart* - the column index of the upper left cell of the subrange *- **Value type**: integer*
* *rowEnd* - the row index of the lower right cell of the subrange - ***Value type**: integer*
* *columnEnd* - the column index of the lower right cell of the subrange - ***Value type**: integer*

#### Remarks <a href="#remarks.30" id="remarks.30"></a>

* *rowEnd* and *columnEnd* could contain the text "last". In this case, all rows / columns until the end of the range are returned.

#### Examples

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-d02daa6645a8b1201b98119796cdbf573fead728%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-472578c69971127f299c442d73fdb4987b4511bc%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-da8b30b4a1f1fcd572f224ef13ef575561dda274%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>