highlight row
 

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

"Wandering Mage" wrote in message
...
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.

highlight row
 

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)

--
Regards,
Tom Ogilvy

"Nigel" wrote in message
...
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

"Wandering Mage" wrote in message
...
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.