1, I've used a lot of VBA codes, and I've never run out of memory just by copying and pasting.
2. There are many ways to release memory. Optimizing code is the best choice in your current situation. Put your macro code out and I'll optimize it for you.