close

Sub InsertBlankRow()
For r = Cells(Rows.Count, quot;Aquot;).End(xlUp).Row To 2 Step -1
Rows(r).Insert Shift:=xlDown
Next r
end sub

quot;Jessquot; wrote:

gt; I need a spreadsheet with a blank row between each row of data. There are
gt; 800 rows of data. Is there an easy way to accomplish this?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()