Rows Insertion
 

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


--
b166er
------------------------------------------------------------------------
b166er's Profile: http://www.excelforum.com/member.php...o&userid=34912
View this thread: http://www.excelforum.com/showthread...hreadid=554555

Rows Insertion
 

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 :-)