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