title: Delete empty ("") rows VBA
body: <p>What I'm looking for:</p>
  <ul>
  <li>I have an Excel workbook, which is build using power query. (works perfectly)</li>
  <li>I have a VBA script to refresh the power query every 4 hours (works perfectly)</li>
  <li>I have a VBA script to extract all sheets to csv (works perfectly)</li>
  </ul>
  <p>But there is a catch, the sheets are build with special characters, so I did create a extra sheet, with all substitutions you could think... (also works perfectly)</p>
  <p>but this extra sheet is using information of 3000 rows. (based on the table extracted from power query). The power query is living, sometimes I need 2000 rows, sometimes 2800 +, this is why I did make the extra sheet based on 3000 rows...</p>
  <p>With the formula:</p>
  <pre><code>=IFERROR(substitutions.....;&quot;&quot;)
  </code></pre>
  <p>The cells on the bottom of the file looks empty, because I did use the &quot;&quot; in the formula, but actually the cells are not empty... So I need a VBA script which will look to the blank cells which are created with &quot;&quot;...</p>