"Procedure Too Large" error message 1

[LouLBI]

I created a file partially by recording, and since it was repetitive, I did some copy/paste with editing. It ended up about 18 pages long, but it wouldn't't execute, and gave an error message of "procedure too large". I can't find any obvious syntax errors, and I didn't know that there was a file size limit.
Thanks in advance for your suggestions.
Lou

 

[xlbo]

please see this link for info:

http://excel.tips.net/T003174_Maximum_Length_Limit_for_a_Macro.html

seems you can;t have more than 64k compiled as a single statement

SOP as per the page would be to break it down into different chunks in private subs and then call each private sub from a master procedure (set the individual subs as private to stop them showing in the macro list)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

chances are that your procedure can and SHOULD be edited to remove MOST of the COPY/PASTED stuff and replace with one or more loops or other coding techniques.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[fumei]

You do not state what application this was recorded in (not a bad idea to do so), but if it was Word ALL recorded macros use Selection, and often a massive amount of extraneous unused (default) parameters. I agree with Skip. It is very likely that judicious editing could reduce things a lot. That along with some "chunking" your code into manageable callable procedures.

Gerry