title: Counting non blank cell results without looping in Excel VBA -- e.g., with Specialcells
body: <p>Here is the code I'm trying to count with in VBA, hoping to return 
  a count return variable of "3" from 'FormulaResultCount'. Why can't I
  count what is visibly returned by the formulas within each cell; from the grey box (see photo below)?</p>
  
  <pre><code> Sub countNonBlanks()
  
          Worksheets("Sheet1").Select
          Range("C:C").Select
  
  
          FormulaResultCount = Selection.SpecialCells(xlCellTypeFormulas).Count
  
  
              'SpecialCells options from MSFT            
              '        xlCellTypeAllFormatConditions. Cells of any format -4172
              '        xlCellTypeAllValidation. Cells having validation criteria -4174
              '        xlCellTypeBlanks. Empty cells 4
              '        xlCellTypeComments. Cells containing notes -4144
              '        xlCellTypeConstants. Cells containing constants 2
              '        xlCellTypeFormulas. Cells containing formulas -4123
              '        xlCellTypeLastCell. The last cell in the used range 11
              '        xlCellTypeSameFormatConditions. Cells having the same format -4173
              '        xlCellTypeSameValidation. Cells having the same validation -4175
              '        xlCellTypeVisible. All visible cells
              '
  
      End Sub
  </code></pre>
  
  <p>See formula as reference:</p>
  
  <p><img src="https://i.stack.imgur.com/Hj56O.png" alt="enter image description here"></p>
  
  <p>Note: Since I will have many more cells when working dynamically, loops will likely slow the process down too much. Also, I tried using CountA without result.</p>