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
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
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 :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks