On 02/09/2006 12:53 RB Smissaert wrote:

Copy the posted code

[snip]

Try it out

Many thanks - it does exactly what I wanted!

It's led me to adapt it and use it in another sheet. This has a value in
B2 updated each day and I've been able to store the maximum ever reached
in J2 and the minimum ever reached in K2.

However, I can't see how to persuade it to work on different values
contained in a range of cells within a column, ie look at B2 and update
J2 or K2, then look at B3 and update J3 or K3 and so on down to, say,
B27 and update J27 or K27.

Further help would be extremely welcome.

--
Frank
(Beware of spam trap - remove the negative)