Rows Insertion

B

b166er

hi members
how can I insert rows after every fiftth row I have data of more than
6000 rows that means I want to insert 2000 rows in that sequence
 
E

excelent

think some like this:
Sub tst()
Dim r
For r = 1 To 6000 Step 5
Cells(r, 1).Activate
ActiveCell.EntireRow.Insert
Next
End Sub

not sure what fiftth means :)
 
Top