Discussion on:

Message 3 of 4
0 Votes
+ -
Here's how to do it with VBA
Sub MyRowDelete()

Dim lRows As Long
Dim lCnt As Long

Application.ScreenUpdating = False
lRows = Cells(1, 1).CurrentRegion.Rows.Count

For lCnt = lRows To 1 Step -1

'*** Note this will delete ODD numbered rows ***
'*** Change to If (lCnt Mod 2) = 0 to delete EVEN numbered rows ***
If (lCnt Mod 2) = 1 Then
ActiveSheet.Rows(lCnt).Delete
End If

Next lCnt

End Sub
Posted by Retired007Geek
Updated - 16th Sep 2009