Is there a way to automatically highlight the column and the row that of the current

zyzzyva57 · #4 02-12-2012, 05:06 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I change the horizontal scrollbar to scroll smoothly rather than column by column	carpat	Excel	0	01-10-2012 09:34 AM
How to call current PC date and/or current PC year	KIM SOLIS	Excel	2	11-04-2011 06:09 PM
Current view filter applies automatically	lumisy	Outlook	3	03-25-2011 05:44 AM
Auto insert current month's name and current year	Styler001	Word	4	01-25-2010 06:40 PM
find - reading highlight - highlight all / highlight doesn't stick when saved	bobk544	Word	3	04-15-2009 03:31 PM