View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
witek witek is offline
external usenet poster
 
Posts: 69
Default 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?