I've managed to get rid of the red text by converting the code to:
Sub highlightrow()
Dim lastrow As Long, i As Long
lastrow = Cells(Rows.Count, 1).End(xlUp)
For i = 1 To lastrow
If Cells(i, "F").Value(i, "F" = 5 And i, "F" <= 7) Then
Rows(i).Interior.ColorIndex = 3
ElseIf Cells(i, "F").Value(i, "F" 7) Then
Rows(i).Interior.ColorIndex = 5
Else
Rows(i).Interior.ColorIndex = xlNone
End If
Next
End Sub
but now I get a Type Mismatch (Error 13) for line
lastrow = Cells(Rows.Count, 1).End(xlUp)
Any ideas
--
Damin
-----------------------------------------------------------------------
Daminc's Profile:
http://www.excelforum.com/member.php...fo&userid=2707
View this thread:
http://www.excelforum.com/showthread.php?threadid=46560