Make a macro loop

P

Paula Tanabe

I would like t create a simple macro that would insert a line every 10 lines in a excel speadsheet that has 500 lines it. Does anyone have any suggestions?
 
T

Tushar Mehta

Depending on your defintion of "every 10 lines", you might have to
adjust the loop control variables in the code below:

Sub testIt2()
Dim i As Long
For i = 500 To 1 Step -10
ActiveSheet.Rows(i).Insert
Next i
End Sub

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Top