Returns the cell reference of a cell on which you have double-clicked.
Syntax:
DOUBLECLICK
Any cell containing the DOUBLECLICK function is recalculated whenever you double-click within the sheet.
Example:
If you put the simple expression
doubleclick
in a cell, that cell will display the contents of the last cell on which you double-clicked.
If you haven't yet double-clicked in a cell, you will get the error Value not defined
returned.