Hi,
I want to highlight the row & column corresponding to the cell which is
currently selected.For that i m using the following macro:-

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

My only problem is that when i am using this & copying that particular
cell,as soon as move it to paste on some other cell my copy command get
cancel.Can anyone help me on this that I can use my excel worksheet i a
normal way & apply all commands on it.