View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steveo[_2_] steveo[_2_] is offline
external usenet poster
 
Posts: 2
Default insert 2 rows and copy and paste

I came across this macro to insert, copy and paste a row. Is there a
way to modify it to insert, copy and paste 2 rows?

Sub AddRows()
Dim lastrow As Long, i As Long
lastrow = Cells(Rows.Count, 1).End(xlUp).Row
For i = lastrow To 1 Step -1
Rows(i + 1).Insert
Rows(i + 1).FillDown
Next
End Sub