title: How to count Blanks in N'th column in a ListObject table
body: <p>I want to count Empty cells (Blanks) in the fourth column only. I tried the following code. </p>
  
  <pre><code>ActiveSheet.ListObjects(1).ListColumns(4).DataBodyRange.SpecialCells(xlCellTypeBlanks).Count
  </code></pre>
  
  <p>In my case, I have a table with only one row and 4'th column has non-empty cell. I get the wrong value with my code. The code above returns 3 Blanks instead of zero - 3 blanks could be total number of blanks in table.  </p>