Knowledge will start from you, SQLjuMBLe for those who Do.
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