> 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/widget-functions/cellref.md).

# CELLREF

#### Syntax

**CELLREF**(*widget*; *rowIndex*, *columnIndex*)

* *widget* - the widget in which the area is to be inserted - ***Value type**: Widget*
* *rowIndex* - the index of the row in which the range is to be inserted - ***Value type**: Number (optional, default value: 1)*
* *columnIndex* - the index of the column in which the range is to be inserted - ***Value type**: Number (optional, default value: 1)*

#### Remarks

* The CELLREF function is always used directly before an assignment operator (=) - see example below.
* rowIndex and/or columnIndex can contain the text "last". In this case, the last row or the last column of the range is used as the index.

#### Example

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