I have a simple problem with the following sub:
For A1 = 0.01 & A2=0.34 values on the "Sheet1" sheet run the following:
tmp = Sheets("sheet1").Range("A1")
If tmp < 10 Then
tmp1 = Sheets("sheet1").Range("A2")
If tmp1 < 10 Then
The problem is that when the value=0.01 (please not the dot instead of comma) the condition is true BUT when the value =0.34 then is false which is not the eexpected result.
Is the format wrong?
Thank You In Advance.