Forum Discussion
Macro using too much memory
Dear Excel experts, I have a few macros witch I stitched together in one big macro. It does work, however sometimes it crashes. Any idea on how to make it more effcient? I would greatly appreciat...
Where would you place the Exit Sub's?
Hi Change99
Click the link I provided and it will explain it to you
basically you put the exit sub in the procedures calls you are making in the main sub, the purpose for that is so your code will not be taking up memory waiting to be excuted and free up memory so excel wont keep rotating before it stops responding.
- Thanks Ill check it out!