Recording maximum and minimum

I have a spreadsheet in which a value is automatically imported into B2
each day.

I would like B3 to automatically show the maximum value ever reached in
B2 and, in B4, the minimum ever reached by B2. Could someone advise me
on how I might do this please.

TIA.

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

Hi F

You can add this to your code

If Range("B2").Value > Range("B3").Value Then
Range("B3").Value = Range("B2").Value
End If

You can do the same for minimum

--
Regards Ron de Bruin
http://www.rondebruin.nl


"F" <news@spinningweb.notnet> wrote in message news:43f73c2f$0$9229$ed2619ec@ptn-nntp-reader01.plus.net...
>I have a spreadsheet in which a value is automatically imported into B2 each day.
>
> I would like B3 to automatically show the maximum value ever reached in B2 and, in B4, the minimum ever reached by B2. Could
> someone advise me on how I might do this please.
>
> TIA.
>
> --
> F
> (Beware of spam trap - remove the negative)

Hi Ron

Thanks for the help: appreciated!

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