IsNumeric

[elgringo56]

I may be using this wrong. Can someone shed some light on it for me? I have the following in my code:
If IsNumeric("D9") = False Then
Code
End If

The problem is, even when Cell D9 contains a number I am returned a False causing the code to execute, which I dont want.

 

[Nimrod]

I find that Loops , conditionals etc all get messed up for this reason... so I always trim my cells before testing for anything ! Seems to save me from lots of errors in my code.

 

[elgringo56]

I dont know if there are chat rooms on this site or not. Its a long question, more of a discussion.

 

[Nimrod]

Might as well attempt it here .

 

[Legacy 98055]

Cell values. I have had similiar problems.
A blank cell returns a data type called "Empty" Different than null. Empty will evaluate to a number with the IsNumeric function.
Another way around this would be the following syntax:

If Not IsNumeric(Sheet1.Range("A1").Text)

By forcing a Cell, which is always a variant, to be evaluated as text, the IsNumeric function will return false if there is not actually a number in the cell.

I don't know if this helps you or not.
The trim statement works fine for the same reason. Causes the cell to be evaluated as a string as well. You could argue that a property assignment uses less resources than inserting another function.
Frankly, I use whatever works and works now.
NWIM?
Tom

Tom