# 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://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/gfxByejg8kZbl32iGoIi/grafik.png" alt=""><figcaption></figcaption></figure>