Solved: Whole row becomes shaded / highlighted when selected

[BENSON]

Can Malcoms code seen below from a previous post be altered to also shade/ highlight the entire row say light grey

[VBA]Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Font.Bold = False
Target.EntireRow.Font.Bold = True
End Sub [/VBA]

THKS

[geekgirlau]

[VBA]Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Font.Bold = False
Target.EntireRow.Font.Bold = True
Target.EntireRow.Interior.ColorIndex = 15
End Sub
[/VBA]

[BENSON]

MANY THANKS

[Bob Phillips]

Don't forget to clear last time

[vba]
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlColorIndexNone
Cells.Font.Bold = False
Target.EntireRow.Font.Bold = True
Target.EntireRow.Interior.ColorIndex = 15
End Sub
[/vba]