On Error Goto ... Error

W

witek

Hi.
I met something strange.
I have 25+ procedures in one module.
Each of them is built as

Sub name
On Error goto ErrHandler
...
exit sub
ErrHandler:
...
end sub




I've started receiving error "Bad DLL calling convention" on exit sub line.
When I renamed ErrHandler to ErrHandler1 ... ErrHandler25, to have
unique name of error handlers for each procedure everything went back to
normal.
Did it happen to anybody? Is there any internal limit in Excel? Another
internal structure without limit checking?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top