I am not an expert but I think there is no <isnumber but use
<isnumeric(expression) for example if D6 is a number
in immediate window type
?isnumeric(range("d6")
it will give <true

mark kubicki wrote in message
...
...trying to us any of the IS functions, and i'm getting a "function not
defined error"; in particular while using the ISNUMBER() function, any
suggestions?


thanks in advance, mark