title: VBA Add Condition to row deletion
body: <p>I am putting the final touches on a macro code however the last bit of line I have included is used to delete rows where data in column A is blank. When I have a situation where there would be blank rows it works fine however if there is no need for a row deletion I am having a debugging issue. How can I change my code posted below to work only when there are extra blank rows based on no information in column A and work the same when there is no need for deletion.  </p>
  
  <pre><code>Range("A7:A" &amp; LastRow).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
  </code></pre>