CELLNO Function

The CELLNO function inserts a cell number as a string into the current cell. It can return either its own cell number or that of another cell.

Syntax

CELLNO(<cell number>)

  • Such that if:

    no cell number is used, the function returns the cell's own cell number, as a string;

    a cell number is specified, it returns the number of that cell, as a string. This reference must be a direct cell reference.

When no cell number is used, the function can be used to figure out what row of a table the current cell is on, as well as a way of linking documents together with the XWKS() calculation.

When a cell number is specified, the function is useful when building calculations that reference particular cells such as the Event calculation SETCELLVALUE or the function SETCELLCALCULATION. If the cells are later renumbered and the CELLNO function is used the cells will rereference properly. It is not necessary to find and edit every calculation that refers to them.

Example 1

Enter CELLNO() in cell A11

This inserts the string A11 in cell A11.

Example 2

Enter CELLNO(ABC.D1) in cell A11.

This inserts the string ABC.D1 in cell A11.

Any rereferencing affecting ABC.D1 will cause the cell reference in this event to be renumbered automatically.

Tip

  • When used with the SetCellValue and SetCellEvent as the target cell, this function allows the program to rereference these calculations.

Related Topics