Sequential numbering and Rows

Hello
I am pretty new to working with Excell but I am learning. :D
I have been lurking/searching and trying to find the solution to my problem.
It consists of basically having the A column continue numbering when I add or delete a row in my sheet I have been working on.

see attached:

If I need to add/delete a line I need it to continue the correct numbering corresponding to the rows.
I dont know how to get it to work if possible?

I appreciate any help.
Thank you.

Hello mkarylyle,

This macro will keep track of the rows as they change. The macro stores the row internally so it can't be corrupted accidentally by the user. Only rows within the table are numbered and the table size is determined automatically. Sheet1 will trigger the macro anytime a cell is changed. When that happens it calls the main macro to check that the rows haven't changed. I have added both of these to the attached workbook.

Worksheet Change Event Code

Please Login or Register  to view this content.

Main Macro Code

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thank you very much!

I have alot to learn