Use the text property of the range and it will always be a string.

Beyond that, you would need a clearer explanation of what you problem is.

--
Regards,
Tom Ogilvy

"Rob" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>