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