ISREF


Tests if the argument is a reference to a cell or range of cells.

Syntax:

ISREF(value)
Returns TRUE if value is a reference to a cell or range of cells and FALSE otherwise.

Example:

ISREF(C5)
returns TRUE, because C5 refers to a cell.
ISREF(A1:B3)
returns TRUE, because A1:B3 refers to a range of cells.
ISREF("A5")
returns FALSE, because "A5" is text, not a cell reference.
ISREF(NA())
returns FALSE, because NA() is an error, not a cell reference.
ISREF(A9999999)
returns FALSE, because cell A9999999 does not exist.
ISREF(range1)
where range1 is the named range A1:B3, returns TRUE.
ISREF(range2)
where range2 is not defined, returns the #NAME? error
ISREF(INDIRECT(C1))
where cell C1 contains the text "D1", returns TRUE, because INDIRECT returns a reference.






 
Created with Zapof