Thinking About Using VBA's IsNumeric Function? Read this first.

[DocAElstein]

Thanks for these ideas, Rick. - I just thought I would mention that, as I passed this Blog post on just now, I saw in that Thread something that might be worth mentioning here in passing, which is that Hans offered an Excel Worksheet function alternative, Application.IsNumber( ) , which seems more likely to give results closer to what most people would expect.
If I understand correctly the main difference between the two functions can be thought of approximately as
IsNumeric( ) is True if it thinks it can convert the given text into a number, whereas
Application.IsNumber( ) is more likely to be True only if the passed thing looks like a number, ( it won't , for example . convert a text into a number, even anything simple like "2" )

That is just an approximate conclusion as I have not investigated thoroughly both functions yet…

The intelligence behind IsNumeric( ) is perhaps a different one to ours, and perhaps as a compromise for efficiency does not thoroughly check for correctness, but rather looks for some allowed characters that might be used in some number formats,
( and it allows a text that has a number format,
( whereas Application.IsNumber( ) doesn’t: For example Application.IsNumber("1") is false because "1" is text )
IsNumeric("1") is True)

Alan

( Edit P.S. I geuss you will need to be in Excel or else load the Excel library in order to use Application.IsNumber( ) )

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://eileenslounge.com/viewtopic.php?p=326972#p326972
https://eileenslounge.com/viewtopic.php?p=326853#p326853
https://eileenslounge.com/viewtopic.php?p=326446#p326446
https://eileenslounge.com/viewtopic.php?f=27&t=41986
https://eileenslounge.com/viewtopic.php?p=325610#p325610
https://eileenslounge.com/viewtopic.php?p=325609#p325609
https://eileenslounge.com/viewtopic.php?p=325605#p325605
https://eileenslounge.com/viewtopic.php?p=325548#p325548
https://eileenslounge.com/viewtopic.php?p=316441#p316441
https://eileenslounge.com/viewtopic.php?p=324736#p324736
https://eileenslounge.com/viewtopic.php?p=324990#p324990
https://eileenslounge.com/viewtopic.php?f=27&t=41937&p=325485#p325485
https://eileenslounge.com/viewtopic.php?p=325609#p325609
https://eileenslounge.com/viewtopic.php?p=325610#p325610
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA