View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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!