View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Harlan Grove[_5_] Harlan Grove[_5_] is offline
external usenet poster
 
Posts: 97
Default Lines in a Module(Procedure)

"Dave Peterson" wrote...
the rule of thumb around here is that procedures shouldn't be bigger than 64k
when you export it to a text file.

But that's just a rule of thumb. I don't think the actual limit is documented
anywhere.

...

64KB in one module I can understand, but 64KB in one *procedure*? Even if lines
of code averaged 64 characters (including the ending newline sequence), that'd
be a 1024 line procedure, so spanning just a bit more than 17 60-line pages in
printout. A single prodedure of that size is a REALLY BAD IDEA!