Procedure too Large !!!
The VB code of one of my UserForm is excedding 64K, so when I compile the code, I get the error message "PROCEDURE TOO LARGE".
Anyone know you to break my 'Big' macro in few 'Small' macros ???
for exemple, a click on a Button will run the code, stored in a module or something like that.
Thanks in advance
You probably need to manually break the code up.
I would think you would go into the Excel menu (tools-Macro-visual basic editor) and open VB.
Once there, locate your macro (probably in the Modules section). Then create a new Sub/End Sub section (named whatever makes sense). Then, in the original sub, pick a point in the part of your code and cut/paste it into the new sub. Then, back in the original sub, put a call to the new sub from the point you cut the code.
Here is a link to an article which explains the code size limitations for modules and such:
Good luck... Kim
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1