highlight row

W

Wandering Mage

OK. So here is my problem. I have a big list-o-stuff,
and it is hard to see what cell you have highlighted on
the other side of the workbook. I know this is the
scripting forum, but many of you are obviously quite
knowledgable about excel. Is there a way within excel to
have the whole row highlight when selected, or something
like that. I don't mind doing it with a macro/event or
something, as long as its not something generic like
having it change the color of the cells within the row
(Interior.Color or whatever it is), because I got a lot of
other junk going on to do that. As always, help is
appreciated! Thanks.
 
N

Nigel

Try putting this is the code behind the sheet you wish to turn row
highlighting on, the selected row is highlighted in yellow.

Option Explicit
Dim z As Long
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
ActiveCell.EntireRow.Interior.ColorIndex = 6
If z = Empty Then
ElseIf Not z = ActiveCell.Row Then
Rows(z).EntireRow.Interior.ColorIndex = xlColorIndexNone
End If
z = ActiveCell.Row
End Sub

Cheers
Nigel
 
T

Tom Ogilvy

as long as its not something generic like
having it change the color of the cells within the row
(Interior.Color or whatever it is)
 
Top