Thursday 21 December 2017

Delete rows from a sheet with an equal number of Intervals in Excel Macros



Sub deleteeveryotherrow()
For x = 3 To 100 Step 1
 Rows(x & ":" & x).Select
    Selection.Delete Shift:=xlUp
 Rows(x & ":" & x).Select
    Selection.Delete Shift:=xlUp
    x = x + 1
    Next x
End Sub

No comments:

Post a Comment