这个方法只能说是半自动的,对付几百行还能将就
如果真的有上万行,还是做个宏好一些
而且也很简单
Sub RowsDelete(Odd As Long)
Dim nRows As Long
Dim i As Long
With Worksheets("sheet1")
nRows = .UsedRange.Rows.Count
For i = nRows To 2 Step -1
If i Mod 2 = Odd Then
.Rows(i).Delete
End If
Next
End With
End Sub
Odd为0时删除偶数行 为1时删除奇数行