On 03/09/2006 20:02 F wrote:

I used the loop.

It was working perfectly if I entered the values manually but if I cut
values from another sheet and paste them into the one with the code the
maximum and minimum cells don't update.

The maximum and minimum cells also fail to update if the data is
automatically read into the sheet in question from another sheet which
is updated with values being entered manually or through cut and paste.

Any idea what I'm doing wrong?

TIA.

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