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