Insert n# of blank rows macro

[fililr]

I will apologize up front since this is my first time posting here. I have searched several threads and can not seem to find exactly what I am trying to do.

I want to make a macro that will insert a specified number of blank rows after the row I am on and continue until it hits the last unused row. I have seen several macros to insert user specified rows but they do not repeat down to the last used row. Not even sure this can be done.

Example:
cat
bat
sat
hat

run macro so 2 blank rows are inserted all the way down from bat to hat:

cat
bat

sat

hat

would be very thankful for any help

[jeffreybrown]

Hello & Welcome to the Board,

How about...

Please Login or Register  to view this content.

Assumes column A and values start at A1

[fililr]

Thank you very much for the response but this does not really do what I need, this seems to go to the bottom of the column and work it's way back up inserting the rows. I am trying to find a way to start on any row and then have a determined amount of rows inserted from that point down to the bottom of the list.

as example:

in column row I may have a list of 30 items and starting at the selected row 10, I want to insert 3 blank rows after each entery from row 10 to the last item in the list