Resume statement can only appear within an error handler and can only be executed in an active error handler. This error has the following causes and solutions:

  • You placed a Resume statement outside error-handling code. Move the statement into an error handler, or delete it.
  • Your code jumped into an error handler even though there was no error. Perhaps you misspelled a line label. Jumps to labels can’t occur across procedures, so search the procedure for the label that identifies the error handler. If you find a duplicate label specified as the target of a GoTo statement that isn’t an On Error GoTo statement, change the line label to agree with its intended target.

 

[efb_likebox fanpage_url="https://www.facebook.com/vbamarket/" box_width="840" box_height=340"" responsive="1" show_faces="1" show_stream="1" hide_cover="1" small_header="0" hide_cta="0" locale="en_US"]