Hi, good morning!!
I have this macro:
Private Sub CommandButton23_Click()
Dim rnArea As range
Dim rnCell As range
Set rnArea = Sheets("sheet2").range("D9", range("D65536").End(xlUp))
For Each rnCell In rnArea
With rnCell
If Not IsError(.Value) Then
Select Case .Value
Case "PZ"
.Interior.ColorIndex = 45
Case "MT"
.Interior.ColorIndex = 20
End Select
End If
End With
Next
End Sub
But I need the inverse function..
I need to highlight & select the row with different value that "PZ" & "MT".. with this macro, highlight me the cell with PZ & MT..
Thanks to help me!
Best Regards!!
Bookmarks