This is what i have come up with
there may be easier ways i dont know....

VB Code:
  1. range("J2:J3").select
  2. Do Until i = range("B1").value
  3. If ActiveCell.Value = "" Then
  4.     Selection.EntireRow.Delete
  5. End If
  6. i = i + 1
  7. Selection.Offset(2).Select
  8. Loop