Insert User Selected Number of Blank Rows

I've scoured the forum and the internet but can't find exactly what I'm looking for.

I want to a macro that will allow me to insert a user specified number of blank rows, based on the cell or row selected by the user. For example I may want to insert 10 blank rows below row 20 and then at another time insert 5 rows below row 35 etc.

I found this code, but it inserts the user specified number of rows between every entry, which I don't want. I simply want to be able to selelct a row, run the macro, enter the number of blank rows to insert below just the selected row and that's it, until the next time I run the macro, when I want it to do the same thing, based on the row selelcted and the number of rows entered.

I don't know enough VBA to know how to do this, so any help would be greatfully received. This code has the basic principal, but I guess I don't want it to loop!

Please Login or Register  to view this content.

Norie,

That's perfect, many thanks. It seems easy when you know how.

Many thanks