title: Excel VBA: Delete entire row if cell in column A is blank (Long Dataset)
body: <p>I am trying to delete all rows that have blank cells in column A in a long dataset (over 60 000 rows in excel)</p>
  
  <p>I have a VBA code that works great when I have less then aprox 32 000 cells:</p>
  
  <pre><code>   Sub DelBlankRows()
  
     Columns("A:A").Select
     Selection.SpecialCells(xlCellTypeBlanks).Select
     Selection.EntireRow.Delete
  
     End Sub
  </code></pre>
  
  <p>Does anybody know a way so that it works on a large number of rows?</p>
  
  <p>Thank you</p>