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" <OptionTrader.24alvm_1141723501.2875@excelforum-nospam.com>
wrote in message
news:OptionTrader.24alvm_1141723501.2875@excelforum-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
>