For i = 1 to 100 {your Code} {your Code} ............ so many rows if you wantNext
Use NEXT and your startvalue, this is for a better clearness.