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
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
Bookmarks