Link to home
Start Free TrialLog in
Avatar of KalluMama
KalluMama

asked on

Procedure Size

Is there a limit on how big a procedure can be? I keep getting an error that my procedure is too big...

Thanks,
KalluMama
ASKER CERTIFIED SOLUTION
Avatar of jkaios
jkaios
Flag of Marshall Islands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of KalluMama
KalluMama

ASKER

cool thanks...i never knew that...i will keep that in mind!!
The following is an excerpt from MSDN.

CAUSE
The maximum size of the internal code for an individual procedure in Visual Basic is 64K bytes. Microsoft Visual Basic for Windows uses Microsoft Visual Basic for Applications, which generates more generic internal code. This generic code allows for compatibility with a wider range of processors. This makes the internal code larger, so it can cause very large procedures to exceed the 64K limit and fail to compile.

WORKAROUND
Split the large procedure into two or more smaller procedures.

STATUS
This behavior is by design.