title: Deleting Empty rows in Excel using VBA
body: <p>I am trying to delete Empty rows by using below code:</p>
  
  <pre><code>worksheet.Columns("A:A").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
  </code></pre>
  
  <p>The code above is working fine, but giving <code>run time error '1004': No Cells were found.</code></p>