title: Excel VBA refering to cell value as #DIV/0
body: <p>Value on cell :   </p>
  
  <pre><code>K12 = 0,    
  K13 = 0 ,    
  K14 = K13+K12
  </code></pre>
  
  <p>which K14 display as <code>#DIV/0!</code></p>
  
  <p>If the value on K14 is more than 7, MsgBox will pop up.<br>
  But since the value is #DIV/0!, VBA does not work.    </p>
  
  <pre><code>Sheets("Passdown Format").Select
  Range("K14").Select
  If Range("K14").Value &gt; 7 Then
  MsgBox "More than 7"
  Else
  End If
  </code></pre>