how to insert a row at regular intervals of row

  • Thread starter Thread starter dsnema
  • Start date Start date
D

dsnema

Hi, I need to insert a row after a regular intervals of 180 rows in a big
data file. How can I enter?
 
Sub insert_them()
For i = 181 To 999 Step 180
Rows(i).Insert Shift:=xlDown
Next
End Sub
 
Back
Top