isnumber()

[mark kubicki]

....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

 

[R.VENKATARAMAN]

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>

 

[Ron Rosenfeld]

...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

ISNUMBER is a worksheet function, so you need to call it using:

application.WorksheetFunction.IsNumber(...)

VBA has an ISNUMERIC function that can be called directly. Look at HELP for
each.


--ron