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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top