Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISNUMBER | Excel Discussion (Misc queries) | |||
ISNUMBER | Excel Worksheet Functions | |||
ISNUMBER | Excel Worksheet Functions | |||
ISNUMBER | Excel Worksheet Functions | |||
ISNUMBER | Excel Programming |