I wasn't sure what you meant, Dee; if you highlight a range, it just changes the highlighting from what it was. Did you mean (I wondered) you wanted to highlight all the cells in the current row
except those that were already highlighted (perhaps a different color)? That can be done, but it involves looking at each cell in the row and highlighting only those that don't have it already.
But I went back and looked; Peco's solution seems to clear out all highlighting everywhere
on the worksheet before highlighting the row. I'm not sure why; that thread was a long time ago and I no longer remember what we may have been thinking then. But if you don't want to do that, this is the culprit:
Code:
Target.Parent.Cells.Interior.ColorIndex = 0
Remove that statement and you should be good.
Actually, that whole thing can be much simpler, if you prefer:
Code:
Private Sub Worksheet_SelectionChange(ByVal org As Range)
Target.EntireRow.Interior.ColorIndex = 8
End Sub
That one statement is all it takes, for something simple like this.