I have an external feed that updates every second. However sometimes it
loses the connection without me knowing. Is there a way to alert me
when this happen? I.e, I need to know when the cell stops updating (it
stas frozen on the last value) , preferably having another cell change
when that happens (so that I can apply a conditional formatting on it
or play a sound).

Many thanks

BC


--
bondcrash
------------------------------------------------------------------------
bondcrash's Profile: http://www.excelforum.com/member.php...o&userid=20997
View this thread: http://www.excelforum.com/showthread...hreadid=394560