Highlight Current Row in Excel (VBA)

[Rick Rothstein]

i found this code, it doesnt change the original highlighted color

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

ActiveSheet.Rows(Target.Row).Select ' highlite entire row
Target.Activate ' select the cell

End Sub

You can simplify that first line of code like this...

Target.EntireRow.Select