In Excel can I automatically highlight the row im working on?
 

When Im working in excel it shere ay way to automatically highlight the
entire row im currently on? so when I moove the bow to a new row the
highlight moves too?

In Excel can I automatically highlight the row im working on?
 

Hi,

I am using the following to highlight current activecell ...

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Cells.Interior.ColorIndex = xlNone
Target.Interior.ColorIndex = 6
End Sub


HTH
Cheers
Carim

In Excel can I automatically highlight the row im working on?
 

Hi,

Chip Person has it at:
http://www.cpearson.com/excel/RowLiner.htm

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"JPAP" escreveu:

When Im working in excel it shere ay way to automatically highlight the
entire row im currently on? so when I moove the bow to a new row the
highlight moves too?