title: How to Make Cells "Blank," not "Empty" in VBA
body: <p>I using Labview to generate a Excel report that essentially pastes an array into the spreadsheet. There are gaps in the spreadsheet, for example:</p>
  
  <pre><code>1
  2
  3
  
  1
  2
  3
  </code></pre>
  
  <p>But because I am inserting an array into the spreadsheet, the gaps are empty, but they aren't blank.</p>
  
  <p>When I run vba code checking each cell using "IsEmpty," it returns true. But if I run an excel formula using "ISBLANK," it returns false. I have tried the following, but it doesn't make the cell blank.</p>
  
  <pre><code>If IsEmpty(Cells(r,c)) Then
      Cells(r,c).Value = ""
      Cells(r,c).ClearContents
      Cells(r,c) = ""
  </code></pre>
  
  <p>I want to make the cells blank without having to delete them. This is because I'm trying to use <code>.End</code> in my VBA code, but it doesn't stop at the gaps.</p>