• Miscellaneous Functions
  • ASSIGNEDTO Function
  • B64TOGUID Function
  • BROWSTAT Function
  • CANSIGN Function
  • CELLCALC Function
  • CELLCOL Function
  • CELLLABEL Function
  • CELLNO Function
  • CELLROW Function
  • CELLSTR Function
  • CELLTABLE Function
  • COMPLETION Function
  • COMPLTBY 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
  • DOCENTSCP Function
  • DOCID Function
  • DOCLIBPATH Function
  • DOCMODE Function
  • EVAL Function
  • FIELD Function
  • GETHIDE Function
  • GUIDTOB64 Function
  • HASTAG Function
  • INITIALS Function
  • INPBLANK Function
  • INPBLANKRC Function
  • ISADMIN Function
  • ISCONS Function
  • ISINGROUP Function
  • ISLOCKED Function
  • ISPLHOLDER Function
  • ISSUECOUNT Function
  • ITEMPROP Function
  • KLIEXIST Function
  • KLIPROP Function
  • KLLPROP Function
  • LEVEL Function
  • LOOKUP Function
  • Miscellaneous Functions
  • MKPATH Function
  • NUMROLES Function
  • NUMSIGNED Function
  • RDYREVIEW Function
  • REPENT Function
  • ROLECOMPLT Function
  • ROLEINDEX Function
  • ROLELABEL Function
  • SCRNX Function
  • SCRNY Function
  • SIGNOFF Function
  • SIGNOFFCHK Function
  • SIGNOFFCVR Function
  • SIGNOFFDTE Function
  • SIGNOFFNME 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