As ALWAYS, post your code for comments.

if not intersect(target,range("a1"))is nothing then

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Paul Kraemer" wrote in message
...
Hi,

I am using Excel 2007. I have written a VBA Sub that I want to be called
any time the value in one particular cell is changed.

I know I can do this by creating a Worksheet_Change() Sub and checking the
'Target' Range parameter to see if the changed cell is the one I want to
watch. The drawback of this is that this Sub gets called any time *any*
cell
is changed. In my case, this will get called alot because I have a value
in
another cell that changes once per second (it displays the current time).

I was wondering if there is an event Sub other than Worksheet_Change()
that
would be called only when the one cell I want to watch changes?

Thanks in advance,
Paul Kraemer
--
Paul Kraemer