I have a list of numbers 1-50.... if I delete a row, I want the
numbers to automatically adjust. The formula I had was
in cell A1 -- 1
In cell A2 -- A1+ 1
IN cell A3 --A2 + 1 etc

If you delete a row, the formulas does not work anymore

any ideas.

Thanks

Chris