Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Highlight changes Kim Excel Discussion (Misc queries) 2 December 17th 09 01:51 PM
how to highlight more related cells if cell highlight Jon Excel Discussion (Misc queries) 5 December 21st 08 01:06 PM
Highlight every other row Bri Excel Discussion (Misc queries) 2 April 5th 06 03:50 PM
Highlight cells with ctrl-click but only un-highlight one cell hagan Excel Discussion (Misc queries) 5 May 27th 05 06:45 PM
how do i highlight every odd row HEATHERSM1 Excel Discussion (Misc queries) 2 May 23rd 05 03:29 PM


All times are GMT +1. The time now is 02:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"