title: VBA-Replacing #N/A with 0 in a named range
body: <p>I am trying to replace #N/A values in my named range, from a previous operation by using this code:</p>
  
  <pre><code>For Each cl In m
      If cl.Value = "#N/A" Then
          Set cl.Value = 0
      End If
  Next cl
  </code></pre>
  
  <p>But this is giving me junk output.
  What am I doing wrong?</p>