Change color of active row
 

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.
--
Craig

Change color of active row
 

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



"Craig" wrote in message
...
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.
--
Craig

Change color of active row
 

Check this out...

http://www.cpearson.com/excel/excelM...ightActiveCell
--
HTH...

Jim Thomlinson


"Craig" wrote:

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.
--
Craig

Change color of active row
 

Thank you both for the suggestions!!
--
Craig


"Craig" wrote:

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.
--
Craig