Select and Delete Every Other Row in Excel Sheet
hi
somthing like this, delete every scecond row
Sub DeleteRows()
Dim i As Long, lastrow As Long
lastrow = Cells(Rows.Count, "A").End(xlUp).Row
For i = 2 To lastrow Step 2
Rows(i).Delete
Next
End Sub
Regards Yngve
|