Thanks Gray for immediate response.

Suppose if I wanted to fire this event only if I edit cells from c1:c10,
then what is the code I required.

Advanced Thanks,
Vinod

"Gary''s Student" wrote:

Put the following macro in the worksheet code area:

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox ("cell " & Target.Address & " was changed")
End Sub
--
Gary''s Student - gsnu200764


"Vinod" wrote:

If I edit data in any cell I wanted VBA code which returns the edit cell
reference.
For this it would be greate for me if any one can provide solution with VBA
code.

Advanced Thanks,
Vinod