Check out the calculation event (in the worksheet module, not a regular
module)
You might be able to set up a dummy cell with a formula and check it each
time the worksheet calculates. Or monitor a cell that has a formula
dependent on the cell you want to watch.

--
steveB

Remove "AYN" from email to respond
"CAP" wrote in message
...

I am trying to get an excel worksheet to email me when a cell value
changes. I have been able to accomplish this if I manually change the
cell data or if it changes by formula.

My problem is, when the cell data changes by receiving new data from a
refresh of "import external data", the data change will not invoke my
send mail macro.

Any ideas?


--
CAP
------------------------------------------------------------------------
CAP's Profile:
http://www.excelforum.com/member.php...o&userid=27720
View this thread: http://www.excelforum.com/showthread...hreadid=472351