Excel Macro inserts row but does not insert next number in row.

G'Day everyone,

I am trying to put a macro in a spreadsheet that will prompt the user to click the button and for the macro to insert a new row and add to the number above.

i.e. insert a new row and number it numerically.


So far...

Please Login or Register  to view this content.

Thanks a million for any help.

Cheers.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

I've added code tags this time.

Your button wil always add a row at Row 27,is this what you want?

Originally Posted by cwayneu

All you basically need is to load the 1st cell of the new row with "=Row()", not "27". That way as more rows get pushed down cell A1 of each row always shows its row value. Something just past the insert like

Selection.Insert Shift:=x1Down
ActiveCell.Range("A1").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=ROW()"

Perhaps you missed that this thread is almost 13 years old now?

haha no problem, I have done that myself a few times already