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)

Recording maximum and minimum
 

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" wrote in message ...
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)

Recording maximum and minimum
 

Hi Ron

Thanks for the help: appreciated!

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