Why do I get error msg "Application-defined or object-defined error" when I Reset in VBA?

[Mackeral]

Shouldn't VBA end at a "Reset" and not give an error message.

And once I click "Ok" on the error message, I can re-execute the macro with no restrictions.

Thanks for your help.

 

[Joe4]

It might be helpful if you can post your code, so we can see exactly how it is written.

 

[Mackeral]

When the program completes, no problem.
There are some EnableEvents on and offs though while the program runs. If I hit Esc and drop into the debugger and try to close VBA or Excel, then I get the error message.
Could that have something to do with the problem?

Mac

 

[Jon Peltier]

Mac -

The error "Application-defined or object-defined error" is about the most common in VBA, and is about the least descriptive.

Joe asked to see some code. Without actual code that includes where the error occurs, it is not possible to help you.