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
|