Change color of active row

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

Guest

I'm wondering if it's possible to have the row of the active cell highlighted
or shaded. As the user moves the cursor up or down, the active row will be
shaded accordingly.

Any suggestions? Thanks.
 
Hi Craig, Try this code. It shows both active Column, and Row. Make
sure the code is place in active worksheet event for
"Worksheet_SelectionChange() "

hth , Rick


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Rows.Interior.ColorIndex = 0
Target.EntireColumn.Interior.ColorIndex = 36
Target.EntireRow.Interior.ColorIndex = 36

End Sub
 

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

How to make active cell border prominent and keep entire active row selected for better visibility 2
EXCEL SPREADSHEET HELP 1
Apply Alternate Shading to selected rows 2
Invalid Circles - Can I force their display? 5
code to shade row then return it to as it was 12
How do I get row and column of active cell to highlight? 2
Highlight Cells in Active Row 5
How to shade groups of rows in excel. 1

Back
Top