How to insert rows after each row of data (800 rows)?
Sub InsertBlankRow()
For r = Cells(Rows.Count, "A").End(xlUp).Row To 2 Step -1
Rows(r).Insert Shift:=xlDown
Next r
end sub
"Jess" wrote:
I need a spreadsheet with a blank row between each row of data. There are
800 rows of data. Is there an easy way to accomplish this?
|