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

J

JPAP

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

Making "Change Highlighting" feature darker 1
Need Help with a VBA subroutine 0
Highlighting a whole row. 4
How do I set focus (and select text) on a text box on a modeless userform? 0
Highlight row 3
highlight the row of the cell Im working in? 11
Turning off automatic calculation 0
Cobditional Formatting Rows based on dates in action plan. 0

Top