View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
libby libby is offline
external usenet poster
 
Posts: 6
Default procedure too large

Yes 64K is the limit for a procedure.
You could try using more variables or splitting your code
into smaller procedures and calling them from each other

-----Original Message-----
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
.