First post here guys.

I'm getting stock prices from retuers. The cells with the feed in it
updates with the price. I need some code which says "when this cell
changes, and only this cell" run this sub.

I've used OnChange but it only seems to work when you manually change a
cell. No good. Oncalculate is just too much as the spreadsheet becomes
unusable and there is no need to reculated everything if the price
doesn't change.

Any help would be greatly appreciated!


Thanks,



Neil.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements