Greetings,

I am sure missing something but just can't see it. When I run the code

If ((NewProd < "") And (NewProd < Prod)) Or (DRun <= 30) Then
More code here
End If

and NewProd = "One", Prod = "One" and DRun = 5, the If passes to the More
code here.

I had previously used:

If ((NewProd < "") And (NewProd < Prod)) Or DRun <= 30 Then

If (NewProd < "" And NewProd < Prod) Or (DRun <= 30) Then

with the same results. To get this to work I ended up using:

If NewProd < Prod Then
If (NewProd < "") Or (DRun <= 30) Then

Would someone explain the error of my ways?

Thanks in advance for your help.

Ray