Adding a new number row but clearing contents of new role

[Armored Wing]

Hi all, I am currently working on a mini excel project where I need to add a new numbered row (i.e 2 to 3 to 4) but with my new rows having cleared contents.

My code right now is the following and I can' t remember how to add the number row. Any help is greatly appreciated. Thank you.

Please Login or Register  to view this content.

[stnkynts]

I'm confused. To me your code already does what you are asking it to do. What am I missing?

[Armored Wing]

To clarify, my spreadsheet on Col A is numbered but I am trying to automated it so that when adding a new row that it keeps it numbered but clear the contents of cell B to E for the new row.

[xladept]

Perhaps the last code line could be:

Please Login or Register  to view this content.

[Armored Wing]

Thank you xladept, I have added rep to you. Just one quick question, since Column A is still static with the numbering of rows. How would i go about in making the numbering automated so that when you add a row, it becomes the next number in sequence?

[xladept]

Hi AW,

Thanks for the rep!

I'm afraid that I don't understand the question