macro

[lealeadupont]

Good morning,
I need to write a macro to insert a new row between every second row but only from row 10 to 20

Someone can help me ??

 

[My Aswer Is This]

Try this:

Sub Insert_Rows()
'Modified 2/3/2022  5:29:58 AM  EST
Application.ScreenUpdating = False
Dim i As Long
    For i = 10 To 20 Step 2
        Rows(i).Insert
    Next
Application.ScreenUpdating = True
End Sub

 

[Fluff]

Duplicate to: macro insert row

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.