Hi everybody,
I'm checking values thru a column but when it gets to #VALUE! is ignoring
the condition and setting the active cell to blue (index 8). Is there anyway
to catch this error and make the condition work?
Any help will be greatly appreciated

....part of code not working...

For i = 1 To LastRow
On Error Resume Next

If ActiveCell.Offset(0, 0).Value "0.895" And
ActiveCell.Offset(0, 0).Value < "1.1049" And _
Left(ActiveCell.Offset(0, -3).Value, 14) = "0.080 = QC STD"
Then
ActiveCell.Offset(0, 0).Interior.ColorIndex = 8

ElseIf (ActiveCell.Offset(0, 0).Value < "0.895" Or
ActiveCell.Offset(0, 0).Value "1.1049") And _
Left(ActiveCell.Offset(0, -3).Value, 14) = "0.080 = QC STD"
Then
ActiveCell.Offset(0, 0).Interior.ColorIndex = 44

'other conditions all working great

End If
ActiveCell.Offset(1, 0).Select
Next i
--
gaba :)