Need Macro Modification for inserting a row and filling down formulas

How do you want to determine the row number?
Do you want it to be say the last row in column x or something like that?

Cheers,

Thank you.

Good question. Would really just like it to be the row directly above the row containing the activation button.

Currently the button is in row 9, so I used row 8 in the record macro feature. But after running the macro 1 time, the button is now in row 10. If I run again, it inserts the new row in row 8, but I would like it to be row 9. And so on...

Alright , got it.
So before using the code, I will ask you to do something:

Go to the row that contains the activation button, select the whole row, go the "NameBox" (its to the left of the formula bar; it shows the adress of the selected cellls), type MyLastRow in the Name Box and click enter. (or you can use any other name that you like, but I need to know it to adjust the code I'm gonna write accordingly.

After doing the naming, you can use this code

Please Login or Register  to view this content.

Thank you.

It is still doing the same thing, because I named row 9 "MyLastRow". So the macro still only inserts the new row in row 8 everytime. How do I get the row name to stay with the row that the button is on?

wow, I'm facing the exact same situation this morning as well. Looking forward to seeing the solution.

This isn't mine, I found it on this website: http://dmcritchie.mvps.org/excel/insrtrow.htm

It will do what we are looking for but not from a button... which I am trying to figure out now.

Please Login or Register  to view this content.

Jeremiah,

I just figured what causes the problem:
Because we don't insert a whole row, the named range doesnt shift as I intended.
We can easily fix the problem by changing the range we name.
So press ctrl + f3 to enter the names menu, and delete the name MyLastRow you gave; then close the naming menu.

Now instead of naming the whole row as MyLastRow, just select the cells in the row of the button, from column a to t.
(i.e. if the button is at row 9, select the range a9 to t9), and name this range as MyLastRow.

Now, the code will work smoothly!

Take Care,

Thank you so much for the help today. Works like a charm.

Anytime