You need to use the worksheet change event (doubleclick the sheet name
in VB Editor) :-

'------------------------------------------------
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$A$1" Then MsgBox ("change")
End Sub
'-------------------------------------------------




lopsided wrote in message ...
Dear all,

I need to call a macro when data is pasted into a particular cell on a
particular worksheet. I am having a few problems with this, any help
would be greatly appretiated.

Many thanks,

Tom


---
Message posted from http://www.ExcelForum.com/