Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Static xRow Static xColumn If xColumn <> "" Then With Columns(xColumn).Interior .ColorIndex = xlNone End With With Rows(xRow).Interior .ColorIndex = xlNone End With End If pRow = Selection.Row pColumn = Selection.Column xRow = pRow xColumn = pColumn With Columns(pColumn).Interior .ColorIndex = 8 .Pattern = xlSolid End With With Rows(pRow).Interior .ColorIndex = 8 .Pattern = xlSolid End With End Sub