Cursor row and column
 

Hi
Is there any way to get colours to the row and to the column where the
cursor is. They should change every time when moving the cursor. Thanks!

Cursor row and column
 

Right click sheet tabview code insert this

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Cells.Interior.ColorIndex = 0
With ActiveCell
.EntireRow.Interior.ColorIndex = 36
.EntireColumn.Interior.ColorIndex = 36
End With
End Sub

--
Don Guillett
SalesAid Software

"Reedhill" wrote in message
...
Hi
Is there any way to get colours to the row and to the column where the
cursor is. They should change every time when moving the cursor. Thanks!

Cursor row and column
 

you may want to try Chip Pearson's Rowliner:
http://www.cpearson.com/excel/RowLiner.htm

Reedhill wrote:

Hi
Is there any way to get colours to the row and to the column where the
cursor is. They should change every time when moving the cursor. Thanks!

--

Dave Peterson

Cursor row and column
 

Thanks both of you. They worked fine.

"Reedhill" kirjoitti:

Hi
Is there any way to get colours to the row and to the column where the
cursor is. They should change every time when moving the cursor. Thanks!