Too many modules?
 

Is there a maximum number of modules/lines of codes for a VB project? I
started getting this error message all of a sudden?
Excel can not complete this task with available resources. Choose less
data or close other applications.
I have 9 modules in the VB project and a total of 850 lines of code.


--
kwiklearner
------------------------------------------------------------------------
kwiklearner's Profile: http://www.excelforum.com/member.php...o&userid=31909
View this thread: http://www.excelforum.com/showthread...hreadid=531574

Too many modules?
 

I have 9 modules in the VB project and a total of 850 lines of
code.

That is far below any limit VBA has. There is a maximum length of
a procedure (a few thousand lines, I think), and a maximum module
size (about 64K when exported to text).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"kwiklearner"
wrote
in message
...

Is there a maximum number of modules/lines of codes for a VB
project? I
started getting this error message all of a sudden?
Excel can not complete this task with available resources.
Choose less
data or close other applications.
I have 9 modules in the VB project and a total of 850 lines of
code.


--
kwiklearner
------------------------------------------------------------------------
kwiklearner's Profile:
http://www.excelforum.com/member.php...o&userid=31909
View this thread:
http://www.excelforum.com/showthread...hreadid=531574

Too many modules?
 

There is maximum to the number of variables.

What the VBA machine does is to first read and interpret your code and wen
it finds no obstructions is will run.
However, if you have a routine where you redefine a variable during loops in
your code and also create new variables, the machine may get overloaded.
You should try putting more variables in an array-variable.

With an array you only haveone variable where you can store unlimited
values.

HTH,

Sybolt