VBA: Run right through my Exit Sub

[hellfire45]

Good day ladies and gentlemen:

So I've got an error handler in this subroutine. When the routine gets to the bottom, it "Calls" another routine, "datacompiler" to run. When this routine finishes, it is supposed to hit the "Exit Sub" and stop. However, instead of stopping, its running through down through my error handler, and closing the workbook.

Does anybody know why my routine is either jumping over, or running straight through my "Exit sub" line?
thank you so much!

(there is a lot of code above where the following code starts. I can post the rest if need be)

Workbooks(docname5).Close False

Call datacompiler

Exit Sub

'----------------------------------------------------ERROR HANDLERS------------------------------------------------------------------
SonGoku:
Application.DisplayAlerts = False
 MsgBox ("Worksheet(aka tab) Missing or wrong name")
 ActiveWorkbook.Close
  Exit Sub

 

[BiocideJ]

Very likely the datacompiler subroutine has no internal error handler and is producing an error which is forcing the err handler from the main sub to skip you to the SonGoku line.

You can step through using F8 and see exactly where the error is occurring.