Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Procedure Too Large
I get a compile error-procedure too large. The sub is 75,188 bytes. What is
the limit? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Procedure Too Large
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Procedure Too Large
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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Procedure Too Large
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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Procedure Too Large
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Procedure too large error | Excel Programming | |||
Procedure too large | Excel Programming | |||
Procedure too large | Excel Programming | |||
procedure too large | Excel Programming | |||
Procedure Too Large problems | Excel Programming |