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

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?
 
C

Carim

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

highlight the row of the cell Im working in? 10
Highlight line working on. 8
Automatically highlight max and min values in a column in Excel 2
Excel Typed text appears in wrong cell 0
Excel VBA - counting cells by colors and names to it in two different rows. 0
AUTOMATIC HIGHLIGHT 1
Highlight more than one entire row when cells = TRUE 5
Conditional Formatting 2 rows only 2

Top