title: How to loop through only the non-empty cell in a column in an excel sheet via VBA?
body: <p>According to <a href="http://www.ozgrid.com/forum/showthread.php?t=138243" rel="nofollow noreferrer">this website</a>. </p>
  
  <p>I think this should work:</p>
  
  <pre><code>Dim cell As Range
  For Each cell In xxxSheet.Range("B:B").SpecialCells(xlCellTypeFormulas, xlNumbers)
      'Do sth.
  Next
  </code></pre>
  
  <p>which does not work. Is there something missing?</p>