Return without GoSub (Error 3)

  • Article

A Return statement must have a corresponding GoSub statement. This error has the following cause and solution:

  • You have a Return statement that can't be matched with a GoSub statement. Make sure your GoSub statement wasn't inadvertently deleted.
  • Return in VBA has a different meaning than that in the Visual Basic .NET.
  • If you want to exit a Sub in VBA, use Exit Sub instead of Return.

Unlike For...Next, While...Wend, and Sub...End Sub, which are matched at compile time, GoSub and Return are matched at run time. For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh).

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.