View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JRW6277 JRW6277 is offline
external usenet poster
 
Posts: 3
Default 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