title: VBA code showing error 2042 for reason unsure
body: <p>I have a variable <code>fila</code> with a full line with Excel's values</p>
  
  <p>The problem is when in Excel I have <code>#N/A</code>, VBA takes that value like <code>Error 2042</code>. </p>
  
  <p>I cannot assign that value to <code>valor</code> <strong>and</strong> produce an error. Until this point  everything is ok, now I am trying to define a <code>On Error Goto</code> to go to the next iteration in the <code>For</code> loop, but I do <strong>not</strong> know why VBA doesn't handle the error.</p>
  
  <pre><code>Do While Not IsEmpty(ActiveCell)
  
      txt = ActiveCell.Value2
      cell = ActiveCell.Offset(0, 1).Value2       
      fila = Range("C20:F20")
  
      For j = 1 To UBound(fila, 2)
          On Error GoTo Siguiente
          If Not IsEmpty(fila(1, j)) Then            
              valor = fila(1, j)
              cmd = Cells(1, j + 2).Value2
              devolver = function1(cmd, txt, cell, valor)
              arrayDevolver(p) = devolver
              p = p + 1                
          End If
  Siguiente:
      Next
  Loop 
  </code></pre>