Hi BT,Originally Posted by bananatang
I wasn't sure if that was inclusive of row three. If not, change to A4. Please note the sheet is not qualified, so works against the active sheet.
[vba]
Option Explicit
Sub exa()
If ActiveCell.Row >= 3 Then
Range(Range("A3"), Cells(ActiveCell.Row, 1)).EntireRow.Delete
End If
End Sub
[/vba]
Hope that helps,
Mark