Highlight Active Row/Column

[Shamsuddeen]

Hi Everybody,

I have a very big worksheet having 1000+ recods and I have to go thru it to find certain value using find command (****+F5).

Whenever I move thru the records, I need the active row (or both active row and column)be highlighted with a background color.


Any help is appreciated.

Regards,

Shamsuddeen

 

[Tom Urtis]

Right click on your sheet tab, left click on View Code, and paste this into the module:

Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Cells.Interior.ColorIndex = 0
Target.EntireRow.Interior.ColorIndex = 8
Target.EntireColumn.Interior.ColorIndex = 8
End Sub

It will hilite the row and column you are in, with a shade of blue. Modify for desired color index number.

 

[Shamsuddeen]

Hi Tom,

Thank you very much. Working very nicely.


Shamsuddeen

 

[purpleski]

Nice code. I love finding things like this but it appears to make copying between cells difficult because having gone to the cell to copy from pressed ctrl-c or clicked on copy when you move to the cell to copy to the copy function is "reset". You can copy and paste by coping within the formula bar but is there anyway of preventing the copy function being reset?

Purpleski

 

[Richie(UK)]

Hi guys,

Don't forget Ivan's HOF entry:

http://www.mrexcel.com/hof001.php

 

[Andrew Poulsom]

See:

http://216.92.17.166/board/viewtopic.php?topic=27217&forum=2

 

[Paul B]

also have a look at The RowLiner add-in @
http://www.cpearson.com/excel/RowLiner.htm