Skip to content

isref

Test whether a value is a cell reference.

v = isref(value)

Returns true if value is a reference (a cell or range). Returns false for direct values, even if they came from cell content.

isref(A1) % 1
  • cell — Information about formatting, location, or contents of a cell.
  • address — Cell address as a text string.