title: Excel VBA multiple error handling in the same procedure
body: <p>I have previously used error handling in VBA successfully, but when trying to use several error handling blocks I can't figure out how to do it.</p>
  
  <p>The code I've written looks like this:</p>
  
  <pre><code>...
  
    On Error GoTo ErrorHandler1
    shpArrow1.Left = shpLine.Left + shpLine.Width * Min(Sqr(Calculations.Range("cVolProduct").value / Calculations.Range("cVolRefIndices").value), 2) / 2 - shpArrow1.Width / 2
    shpTag1.Left = shpLine.Left + shpLine.Width * Min(Sqr(Calculations.Range("cVolProduct").value / Calculations.Range("cVolRefIndices").value), 2) / 2 - shpTag1.Width / 2
    shpArrow2.Left = shpLine.Left + shpLine.Width * Min(Sqr(Calculations.Range("cVolUnderlyings").value / Calculations.Range("cVolRefIndices").value), 2) / 2 - shpArrow2.Width / 2
    shpTag2.Left = shpLine.Left + shpLine.Width * Min(Sqr(Calculations.Range("cVolUnderlyings").value / Calculations.Range("cVolRefIndices").value), 2) / 2 - shpTag2.Width / 2
    shpIndexLine.Left = shpLine.Left + shpLine.Width / 2 - shpIndexLine.Width / 2
    GoTo NoError1
  ErrorHandler1:
    shpArrow1.Left = shpLine.Left - shpArrow1.Width / 2
    shpTag1.Left = shpLine.Left - shpTag1.Width / 2
    shpArrow2.Left = shpLine.Left - shpArrow2.Width / 2
    shpTag2.Left = shpLine.Left - shpTag2.Width / 2
    shpIndexLine.Left = shpLine.Left + shpLine.Width / 2 - shpIndexLine.Width / 2
    errorRelativeRisk = 1
  NoError1:
    On Error GoTo 0
  
    On Error GoTo ErrorHandler2
    Output.ChartObjects("ChartHistoryUnderlyings").Activate
    ActiveChart.Axes(xlValue).CrossesAt = ActiveChart.Axes(xlValue).MinimumScale
    ActiveChart.Axes(xlCategory).CrossesAt = ActiveChart.Axes(xlCategory).MinimumScale
    GoTo NoError2
  ErrorHandler2:
    errorHistUnderl = 1
  NoError2:
    On Error GoTo 0
  
  ...
  </code></pre>
  
  <p>The second error handling block does not work. I'm guessing that I don't quit the first error handling block correctly. Have tried to find an answer that works for me but without success.</p>
  
  <p>Greatful for any help!</p>