I'm sure this is simple, but I can't seem to find it anywhere.
I'm doing an If/then that performs some < and > comparisons, but
there are some #REF error fields mixed in as well. My script chokes
when it hits the error messages, because I'm trying to perform < and
> comparisons on text.
What do I use in my first If statement that will allow it to skip
fields that don't have numbers?
If Cells(Tallyrow, 13).Value **ISN'T A NUMBER**
End if
ElseIf Cells(Tallyrow, 13).Value > 0 And Cells(Tallyrow, 13).Value <
2 Then
Sheets("Email").Select
Rows(Emailrow).Select
With Selection.Interior
.ColorIndex = 44
.Pattern = xlSolid
End With
ElseIf Cells(Tallyrow, 13).Value > 1.999 And Cells(Tallyrow,
13).Value < 3 Then
Sheets("Email").Select
Rows(Emailrow).Select
With Selection.Interior
.ColorIndex = 36
.Pattern = xlSolid
End With