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 sequenc
 
B

Bob Phillips

For i = 6000 To 5 Step -5
Rows(i).Insert
Next i

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Top