View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
CJ CJ is offline
external usenet poster
 
Posts: 102
Default How do i insert blank rows between data that is thousands of r

what would the formula be if I wanted to insert 2 blank rows after each
existing data row?

"HKaplan" wrote:

Edit this simple macro:

Sub RowInsert()

For X = 2 To 12000
Rows(X).Select
Selection.Insert Shift:=xlDown
X = X + 1
Next X

End Sub