I'm trying to create a table where the list numbers dynamically update
from 1 to the end of the list. Currently, I have the numbering so that
row one, is shown as "1", and then row two has a "=A1+1" function. I
can then copy the row two formula for the remaining cells, and it adds
accordingly. If I insert a new row, the formulas correct the numbering
as it should.

The problem is, if I start deleting rows, then all the rows below the
deleted row get REF! errors. What's the easiest way to avoid this? I
would like a dynamically stable list that will keep it's numbering
correct as I add and remove rows. Is there a way to do this with a
CELL() function perhaps?

Let me know if I need to explain further.


--
Excl
------------------------------------------------------------------------
Excl's Profile: http://www.excelforum.com/member.php...o&userid=37897
View this thread: http://www.excelforum.com/showthread...hreadid=574316