isnumber()
 

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

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

isnumber()
 

On Thu, 4 Nov 2004 21:29:40 -0500, "mark kubicki"
wrote:

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