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.

[Mudface]

Try the following: -

If Not IsNumeric(Range("D9").Value) Then
Code
End If

Brought to you courtesy of the Breeders and Cannonball.

[elgringo56]

Thank you, I shall give that a try

[Nimrod]

Thats because your not refering to a cell your just testing a text string i.e. what ever you put into quotes is text. Here this code will do the job for you.

If Not IsNumeric(Trim(Range("D9").Value)) Then
'place code here
End If

[Nimrod]

Mudface solution is almost correct other then it will test a blank cell as holding a value of Zero.... which is a number! If you don't want blank cells testing true as a number then use my solution with the added trim function in it.
If Not IsNumeric(Trim(Range("D9").Value)) Then
'place code here
End If


[ This Message was edited by: Nimrod on 2002-05-04 18:26 ]

[ This Message was edited by: Nimrod on 2002-05-04 18:27 ]

[elgringo56]

Ok, Nimrods worked, but I will be darned if I know why. I dont understand this one at all. That being said, thanks a lot, you got me going

[Nimrod]

Without trimming you have an empty string which is evaluated to zero. The trim command means that the empty string is removed therefore eliminating the evaluation to Zero.

[elgringo56]

Nimrod, can we get in a chat somewhere, you may be giving me the answer to a question that has nagged me for a long time concerning "empty" cells.

[Mudface]

Aye, sorry, should've been the code below to check for a blank cell too: -

If Not IsNumeric(Range("D9").Text) Then
Code
End If

All the code is saying is that if the cell d9 contains anything but a number then ...

[Nimrod]

My email is presently down .. is there any chat rooms on this site ? ... or you could ask the question here ?