If Then number format
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
|