title: Highlight cells in a range that are "hard-coded" and not formula derived
body: <p>I found this code on Stackoverflow <a href="https://stackoverflow.com/questions/21388721/vba-highlight-hardcode-cell-i-e-1234-in-excel-after-model-is-built">VBA (highlight Hardcode cell (i.e.1234) in Excel) after model is built</a></p>
  
  <pre><code> Public Sub hightlightNoFormulas()
      Dim yourRange as Range, rangeNoFormula as Range
      Set yourRange = Range("A1:A100")
      Set rangeNoFormula = yourRange.SpecialCells xlCellTypeFormulas
  
  Then loop through your range, excluding any values that have formulas  
  
      Dim rng as Range
         For Each rng in yourRange
            If Intersect(rng,rangeNoFormula) Is Nothing Then
                 rng.interior.Color = 65535
            End If
         Next rng
      Exit Sub
  </code></pre>
  
  <p>Although the <strong><code>"Set rangeNoFormula = yourRange.SpecialCells xlCellTypeFormulas"</code></strong> section errors out in Excel 2010.  I have been looking for code that highlights cells in a selectable range that are "hard-coded" and not formula derived (i.e where cell formula was over-typed).  Can someone please provide help?  Thanks.</p>