Don't include a cell reference within ROW()... i.e. just use =ROW()

--
Regards,
Dave


"NewKid" wrote:

Hello,

I am trying to automatically number rows in a worksheet. I have used the
=ROW(A1) function and that works alright, BUT it doesn't re-adjust
automatically after a row has been deleted or inserted. I also tried
selecting the range and creating it as a LIST, which works when we delete a
row, but when I insert a row, I have to double-click on the cross-hair on the
bottom right corner of the previous cell.

Does anyone know a way around this?

MANY thanks!!