Use a worksheet change event by right click on sheet tabview codeinsert
thismodifysave
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$F$1" Then Exit Sub
Call mysub
End Sub
Sub mysub()
MsgBox "Hi"
End Sub

--
Don Guillett
SalesAid Software

"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/