Insert Multiple Blank Rows
Thank you so much, TK. It worked perfectly.
"T Kirtley" wrote:
CJ,
Try the following modified code:
Sub RowInsert()
For x = 2 To 12000
Rows(x & ":" & x + 1).Select
Selection.Insert Shift:=xlDown
x = x + 2
Next x
End Sub
Hope that helps,
TK
"CJ" wrote:
How do I insert 2 blank rows after each line of data? I have a very large
spreadsheet that I need to format and upload into an accounting application.
The format requires that two blank rows follow each line.
I used the below macro but, it only inserts one row rather then two.
Sub RowInsert()
For X = 2 To 12000
Rows(X).Select
Selection.Insert Shift:=xlDown
X = X + 1
Next X
End Sub
|