If/Then - EASY
 

I have the following If/Then statement in a macro, the problem is when the
value of the K9 is less than 10 it isn't identified correctly by the if
statement. Is there some easy fix like changing the number format I'm
missing?

If Range("K9") < "37.5" Then
Call Message
Else
Call Macro1
End If

If/Then - EASY
 

Your macro is testing for text. To test for a number you need:

If Range("K9") < 37.5 Then


HTH
Bob

"JRW6277" wrote in message
...
I have the following If/Then statement in a macro, the problem is when the
value of the K9 is less than 10 it isn't identified correctly by the if
statement. Is there some easy fix like changing the number format I'm
missing?

If Range("K9") < "37.5" Then
Call Message
Else
Call Macro1
End If

If/Then - EASY
 

I knew is was something silly like that. Thanks Bob

"Bob Alhat" wrote:

Your macro is testing for text. To test for a number you need:

If Range("K9") < 37.5 Then


HTH
Bob

"JRW6277" wrote in message
...
I have the following If/Then statement in a macro, the problem is when the
value of the K9 is less than 10 it isn't identified correctly by the if
statement. Is there some easy fix like changing the number format I'm
missing?

If Range("K9") < "37.5" Then
Call Message
Else
Call Macro1
End If