> 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

Inserts an area at a desired position in a table widget.

#### 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="https://3148043601-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL43fiRbeRtPnTjMpbGNO%2Fuploads%2Fgit-blob-1c0865c031f9588bc8896b9b8f79e3ab60032421%2Fgrafik%20(531).png?alt=media" alt=""><figcaption></figcaption></figure>