> 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/nedyx/clearlines-functions/range-functions/range.md).

# 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="/files/KPEFIUu6buMsZYPHIS9S" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/Xh6hHZFtt1ShMasEv8IG" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/SoOiA5GpEBpZUIDIBUX5" alt=""><figcaption></figcaption></figure>