title: Excel VBA - Delete empty rows
body: <p>I would like to delete the empty rows my ERP Quotation generates. I'm trying to go through the document (<code>A1:Z50</code>) and for each row where there is no data in the cells (<code>A1-B1...Z1 = empty</code>, <code>A5-B5...Z5 = empty</code>) I  want to delete them.</p>
  
  <p>I found this, but can't seem to configure it for me.</p>
  
  <pre><code>On Error Resume Next
  Worksheet.Columns("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
  On Error GoTo 0
  </code></pre>