• Miscellaneous Functions
  • Miscellaneous Functions
  • BROWSTAT function
  • CELLCALC function
  • CELLCOL function
  • CELLLABEL function
  • CELLNO function
  • CELLROW function
  • CELLSTR function
  • CELLTABLE function
  • CUSTPROP function
  • CUSTPROPAT Function
  • CUSTPROPR function
  • CVDATA function
  • CVDATAC function
  • CVDATAL function
  • CVDATALNG function
  • CVDATAQRY function
  • CVDOCPOS function
  • CVFORM function
  • CVGROUP function
  • CVIDEA function
  • CVINFO function
  • CVMENUST function
  • DOCID function
  • DOCMODE function
  • EVAL function
  • GETHIDE function
  • INITIALS function
  • ISCONS function
  • ISINGROUP function
  • ISINGRP function
  • KLIEXIST function
  • KLIPROP function
  • KLLPROP function
  • LEVEL function
  • LOOKUP function
  • MKPATH function
  • RDYREVIEW function
  • REPENT function
  • SCRNX function
  • SCRNY function
  • WHOAMI function

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

• Miscellaneous Functions