Error Handling problem Excel 2013

Topic

New Reply

For some reason the error handing in a macro enabled workbook is not picking up when there is an error and dealing with it using an error handling code.
The lines are>

On Error GoTo err_Assignments
Worksheets(“ASSIGNMENTS”).Activate

Because the ASSIGNMENTS worksheet does not exist then I should be trapping this error and seeing a separate message to say the error has occurred

The error handling is for now
err_Assignments:
MsgBox Err.Number & ” – ” & Err.Description

It doesn’t catch the error and it throws the Run-time error ‘9’:
Subscript out of range

I tried on error resume next but still the runtime error is being displayed

Have I missed a new setting in 2013?

thanks
alan

Reply | Quote

Replies

Darn it – simple settings check would have resolved this…apologies.

Tools>Options>General> make sure error trapping is set as ‘Break on Unhandled Errors’

Reply | Quote

Hi

In the VBA editor, it would be better to use..
Tools>Options>General> make sure error trapping is set as ‘Break In Class Module’

The reason is that if an error occurred in say, a Userform’s vba code, then the debugger will stop at the relevant line of code that caused the problem in the Userform’s code.

zeddy

Reply | Quote