How do I end an Error Resume Next Procedure? 2

[clrc]

Hi...need your help. After my macro runs the ErrorCapture procedure, it still goes to the third line and runs all the codes after. I'd like it to stop after it runs the error capture.
Below is the code.

Sub Macro1()
Call ErrorCapture 'SUB PROC
Sheets("RAW SEGMENT REPORT").Select

Hope you can help.

Thanks!

 

[combo]

When you call a procedure the code continues at next line after quitting it. Rather redesign your code, for instance convert your procedure to function returning error flag (T/F) or add ByRef argument to the procedure argument list..

combo

 

[VulcanJedi]

on error goto 0 is the inverse of on error resume next

Tranpkp