I want to insert a new row everyother row. How can I do that?
I want to insert a new row everyother row. How can I do that?
Use this macro:
Sub Macro1()
For i = 2 To 10 Step 2
Range("A" & i).Select
Selection.EntireRow.Insert
Next
End Sub
Best regards,
Ray
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks