title: Using IFERROR in VBA
body: <p>I hope someone can help me please?  I've done a lot of googling and can't figure out what the issue is.  I only dabble in vba, so I'm certainly no expert...</p>
  
  <p>I am trying to automate some calculations in a huge spreadsheet at work, and I think I'm probably missing something really silly.  Basically, one of the calculations is a simple divide of one cell by another cell.  When it hits an error, I want it to return a 0.  Here is the code that keeps tripping over:</p>
  
  <pre><code>Sheets("Bridge").Range("W" &amp; SumIfInt) = Application.WorksheetFunction.IfError(Sheets("Bridge").Range("AA" &amp; SumIfInt) / Sheets("Bridge").Range("D" &amp; SumIfInt), 0)
  </code></pre>
  
  <p>I get a Run-time error 6 Overflow</p>
  
  <p>Thanks in advance</p>