ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   On Error Goto ... Error (https://www.excelbanter.com/excel-programming/373137-error-goto-error.html)

witek

On Error Goto ... Error
 
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?




All times are GMT +1. The time now is 04:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com