title: Understanding the syntax of "special cells" in Excel VBA
body: <p>I have a part of my code that looks like this:</p>
  
  <pre><code>With Selection
      Set ConstantCell = .SpecialCells(xlCellTypeConstants, xlNumber)
      Set FormulaCell = .SpecialCells(xltypeformulas, 21)
  End With
  </code></pre>
  
  <p>It is part of a macro to color cells with different types of data in them. I understand what this part does but what I want to ask is what does the <code>21</code> represents? I found that in the syntax of this formula it represents some value and I thought that it would only select the cells which have formulas and equal to 21 but that was not the case when I ran the whole macro.</p>