Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Highlight changes | Excel Discussion (Misc queries) | |||
how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
Highlight every other row | Excel Discussion (Misc queries) | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
how do i highlight every odd row | Excel Discussion (Misc queries) |