How to insert rows after each row of data (15,452 rows)?
I need a spreadsheet with a blank row between each row of data. There are
15,452 rows of data. I saw your answer below, but don't understand how or
what program I need? Can you please help?
"Toppers" wrote:
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?
|