How do I insert a row ...

F

fzl2007

I want to insert a blank row every two rows, with the consideration
that my first row is the title.

Thanks.
Faye
 
J

joel

the best way is to go from the end of the sheet back to the beginning
like this


Lastrow = Range("A" & rows.count).end(xlup).row
for rowcount = Lastrow to 1 step -2
Rows(RowCount).insert
next rowCount
 
Top