I don't think I could really agree with that. 20 lines is extremely short. I
try to have logical organization of code and I use lots of appropriately
named modules, too, but just try not to have so much you have to do a bunch
of scrolling. Also keep your lines short. Use lots of line breaks and good
comments.
--
HTH
Richard Choate, CPA

"Myrna Larson" wrote in message
...
FWIW, the "pros" say that a single procedure should fit entirely on one
screen, i.e. no more
than about 20 lines.

On Thu, 7 Aug 2003 09:34:56 -0700, "Ad van Zutphen"
wrote:

I got following message after compiling in Excel97:

Procedure too large

64K seems to be the limit. Is there a way to bypass this,
without breaking up the macro?

Regards,

Ad