iWiishh
05-14-2012, 10:38 AM
Hi, i'm kinda facing some problem
The actual coding is alot more complicated, but i kinda narrowed down my problem to this.
I've got lots of conditions and like
If 2 - 4, then
else if 5-6 then
But the problem now is,
Say i've got a cell in excel B2 value is 2000 which means cells(2,2) is 2000 right?
But when i tried to trouble shoot using msgbox, I did msgbox(200<= cells(2,2) <=300), why does it give me a true? it should be a false righT? since 2000 is no where in between 200 and 300.
Thanks!
The actual coding is alot more complicated, but i kinda narrowed down my problem to this.
I've got lots of conditions and like
If 2 - 4, then
else if 5-6 then
But the problem now is,
Say i've got a cell in excel B2 value is 2000 which means cells(2,2) is 2000 right?
But when i tried to trouble shoot using msgbox, I did msgbox(200<= cells(2,2) <=300), why does it give me a true? it should be a false righT? since 2000 is no where in between 200 and 300.
Thanks!