Programmatically assign line numbers

[freebird_wr]

Hi,

I have a macro that I have had modified to accomplish various tasks. For standardization, I need it to assign line item numbers instead of users doing it. The macro copies a worksheet template multiple times, renames them, and copies various pieces of info to the sheets based on the main worksheet. The user deletes any rows of data they do not want copied. However, I need the line numbers to remain sequential. The attached sheet shows the layout of the main worksheet. Is there a way to do this - remove the line numbers from the main sheet and assign with code? Attached is a view of the main worksheet ("Fill This Out First").

Please Login or Register  to view this content.

[JBeaucaire]

Instead of needing VBA to do fancy row renumbering, let the worksheet do the work. Put this formula in C5 and copy down:

=TEXT(ROW()-4, "0000")


That should keep the rows numbered when one is deleted randomly in the middle.