Read this entire thread:

http://tinyurl.com/l5qos

Make sure you also follow the link near the bottom of the thread where Gord
Dibben is mentioned. His suggestion is your BEST option.

Biff

"OptionTrader"
wrote in message
news:OptionTrader.24alvm_1141723501.2875@excelforu m-nospam.com...

jimbob

I need to do this too.

There is a way, it's been written on these boards before and involves
about 5 or 6 cells and circular references. Quite complicated if I
remember rightly. Do you think I can find it ???

Hopefully someone will know.

Just to re-state the problem;

Recording the highest and lowest value that has ever appeared in a
single cell.

TIA.


--
OptionTrader
------------------------------------------------------------------------
OptionTrader's Profile:
http://www.excelforum.com/member.php...o&userid=14954
View this thread: http://www.excelforum.com/showthread...hreadid=519518