Compile Error - Procedure too large

  • Thread starter Thread starter LB79
  • Start date Start date
L

LB79

Ive created a macro that was rather large and Excel threw a tantrum and
told me off so i split the macro in to two (different modules) but i
still get a compile error - procedure too large. Excel help says that i
can go up to 64KB - my macro is now only 52KB - does anyone know whats
going on or how i can increase the allowable size of a macro?

Thanks
 
LB79

Try exporting the modules, deleting them, then re-importing. That can clean
out some left over junk that accumulates. That said, 52K is still a lot for
one module. You should consider splitting it further.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compile Error: Procedure too large 1
Anyone Else Facing Public Folder Migration Errors in Exchange? 0
VBA Compile error: Procedure too large? 1
procedure is too large 2
Excel Macros 1
Compile Error: Procedure too large 1
Visual Basic sub routine command?? 1
The picture is too large and will be truncated."-excel Warning 0

Back
Top