On 05/09/2006 00:01 RB Smissaert wrote:

Try commenting out this bit:
If Target.Cells.Count = 1 Then
With the corresponding End If.

Thanks for the suggestion but the maximum and minimum cells still don't
update.

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