# 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="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>