I have tried for several hours and failed.
I want, say, A1 to contain 1.
I want A2 to self generate its value as the cell above +1
etc. etc. but of course NOT using A1+1 because...

...if I delete one of the numbers in the sequence, I want that cell to
become blank and all the remaining cells below to regenerate their
numbers to remain sequential regardless of the blank or several
blanks.
One further limit is that if the renumbering hits a red cell (or
several) then it misses them and continues below.

I have tried Address(), row(), column() etc in various combinations to
no avail.

I would be pleased if someone could solve this for me.

Thanks


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