Insert number of user inputted rows without copying pre-existing data

Hi all,

I have a formula that pastes rows into the excel sheet based on how many rows the user wants. However, it copies over pre-existing data.

Can anyone modify this VBA so it shifts all of the rows down?
Additionally, is it possible to copy the previous row and paste it instead of inserting new rows?

Please Login or Register  to view this content.

Thanks for the help!

the best way to learn VBA is to record macros, set a macro recording and then do what you want to do, for instance highlight the number of rows you want to insert, right click, select Insert and answer any questions that come up.

Then stop the macro, go into VBA and a new module should exist that will hold all the code from your actions. That way you can get it to do exactly what you want and see the exact code that does it. The simply lift the bit(s) that are relevant and modify them for variables etc in your code.

works for me as is.