I get a compile error-procedure too large. The sub is 75,188 bytes. What is
the limit?

I've never seen a limit documented by Microsoft.

Rule of thumb is about 64k.



Mike H. wrote:

I get a compile error-procedure too large. The sub is 75,188 bytes. What is
the limit?

--

Dave Peterson

The number of lines can do it as well...


"Mike H." wrote in message
...
I get a compile error-procedure too large. The sub is 75,188 bytes. What
is
the limit?

Are you saying your sub, ie a single routine, that when saved to a text file
is 75k, as distinct from a code module of multiple routines.

If so, thank the compiler for flagging and reconstruct into many smaller
subs & functions.

Regards,
Peter T

"Mike H." wrote in message
...
I get a compile error-procedure too large. The sub is 75,188 bytes. What
is
the limit?

That is what I am saying, it is 75k worth of text. And to solve the problem,
I did break it out until it would run.