Adding a specified number of rows in Excel, via a User Form

Joined
Jun 21, 2011
Messages
1
Reaction score
0
Hello,

I am trying to create a User Form to use with a new Excel log I am setting up, and I'm stumped on how to get a specified number of rows inserted.

The User Form I have includes a Combo Box with some set numbers in, currently 1 - 13. What I would like is on clicking OK, whichever number was specified in the combo box is how many new rows are inserted.

I already have the code to find the last row used, so I now just need the new rows inserted. I also ideally need them to retain the formatting of the rows above them. Any idea's?

Also, while I'm here, I then need to insert information from other fields on the User Form, for example a specified script name, into those boxes that I have just inserted. Is this possible or am I getting away from myself?

Any help would be greatly appreciated.

Thanks
Apollo
 
Back
Top