Compile Error - Procedure too large

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
 
D

Dick Kusleika

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.
 
Top