DOUBLECLICK

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.