I've always have trouble with this one could someone help?
I can determine if a cell has a numeric value but not a string value.
Sometimes I can get it to work but for some reason it's not very reliable?
As a result need a more definate code.
I have attached the macro, it is range 02 that is giving me grieve

If Range(range01) 0 And Range(range02) < 0 Then

It was as below which worked sometimes works

If Range("B1") = "" And Range("C1") < "" Then