Microsoft Office Forums - View Single Post - Is there a way to automatically highlight the column and the row that of the current

Jamal NUMAN · 02-13-2012, 12:48 AM

Quote:

Originally Posted by zyzzyva57

Try this code:

Code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Cells.Count > 1 Then Exit Sub
    Application.ScreenUpdating = False
    ' Clear the color of all the cells
    Cells.Interior.ColorIndex = 0
    With Target
        ' Highlight the entire row and column that contain the active cell
        .EntireRow.Interior.ColorIndex = 8
        .EntireColumn.Interior.ColorIndex = 8
    End With
    Application.ScreenUpdating = True
End Sub

Thank you for the answer zyzzyva57. that's perfect. this is exactly what I'm looking for.

thank you guys for the help

appreciated

Jamal