title: Find inconsistent formulas in Excel through VBA
body: <p>Excel detects if a formula is inconsistent with a calculated column in a table and shows them with a little green triangle (which says "This cell is inconsistent with the column formula"). How can I find them through VBA. I found this code that is supposed to do the trick (from <a href="http://www.ozgrid.com/forum/showthread.php?t=145306" rel="nofollow">http://www.ozgrid.com/forum/showthread.php?t=145306</a>) but this only works when the used range is a normal range instead of a table:</p>
  
  <pre><code>Dim oneCell As Range 
  
  For Each oneCell In ActiveSheet.UsedRange 
      If oneCell.Errors(xlInconsistentFormula).Value Then 
          oneCell.Interior.ColorIndex = 6 
      Else 
          oneCell.Interior.ColorIndex = xlNone 
      End If 
  Next oneCell 
  </code></pre>
  
  <p>But <code>oneCell.Errors(xlInconsistentFormula).Value</code> only sends "False" so it doesn't work.</p>
  
  <p>Can this be fixed to work in a table instead of a normal range?</p>
  
  <p>Edit: xlInconsistentFormula doesn't do anything if you work in a table.</p>