> For the complete documentation index, see [llms.txt](https://docs.nedyx.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/range-functions/range.md).

# RANGE

Returns a part of a 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://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/4NcHaN2Si33jU6ESX0dj/grafik.png" alt=""><figcaption></figcaption></figure>

<figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/3QN4LUXtk6IeBdonFDne/grafik.png" alt=""><figcaption></figcaption></figure>

<figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/Ae0FjWMlnuwaOqbdlyT9/grafik.png" alt=""><figcaption></figcaption></figure>