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