title: If range contains errors, clear errors VBA
body: <p>New to VBA and stackoverflow.</p>
  
  <p>I want to search a worksheet and if there are errors (#N/A etc.) I would like to clear them. If there are no errors do nothing.</p>
  
  <p>I used:</p>
  
  <pre><code>Cells.SpecialCells(xlCellTypeFormulas,xlErrors).Clear
  </code></pre>
  
  <p>which worked fine when there are errors but if there are no errors I end up in debug mode.</p>
  
  <p>Any suggestions?</p>
  
  <p>Thanks!</p>