Hi,

There are size limits, but you're unlikely to hit them. Compilation errors
are usually coding bugs that the compiler can't deal with, in my
experience
most commonly relating to procedure declarations. Try running the project
without compiling and test thoroughly ... the bad code usually shows up
pretty quickly.
It doesn't seems as code problem. It's invariant to code content, but
depends on code size...
here's my answer to another respondent:
A was coding in VB6, then I've created empty Excel Spreadsheet and imported
a code as VBA project and then tried to compile but there was Excel crush. I
tried to delete one function and code was compiled successfully, then I
tried to uncomment this function and comment other function. code was
compiled successfully, but when I tried to uncomment both functions, excell
crashed down :( (I've tried also with another functions and the same thing
happened)...


Best Regards,
Levan Jgarkava


Hi!

I've got a question: Is there any size limitations on VBA Project?
Situation: I'm creating VBA classes and modules in MS Excel 2000
(9.0.2812)
and after some additions(no matter what) I can't
compile VBA project. There's an exception error signatu
-----
AppName: excel.exe AppVer: 9.0.0.2719 ModName: vbe6.dll
ModVer: 6.3.91.8 Offset: 00083676
-----

Thanks.

--
Best Regards,
Levan Jgarkava