Thanks for looking at this Ron

I have tried it. A1=1 then paste to A2 it gives 2, I then have to copy
and paste to all other cells and it generates the sequence. Part one OK
thanks.

The requirement (my para 2) to re-generate if one of the cells is
deleted does not happen. Nor does it skip cells containing a colour.
These two are the main aims.

Once the numbers are in, the above is required to happen automatically
as I delete a cell, they renumber below that point.

Regards


--
donone
------------------------------------------------------------------------
donone's Profile: http://www.excelforum.com/member.php...o&userid=27237
View this thread: http://www.excelforum.com/showthread...hreadid=467475