Sub Del()
ttlRow = InputBox("Input last line of the number of rows:")
currentrow = 0
Range("A1").Select
Do
If IsEmpty(ActiveCell.Value) Then
Selection.EntireRow.Delete
Else
ActiveCell.Offset(1, 0).Activate
End If
currentrow = currentrow + 1
Loop Until currentrow > ttlRow