> Rubberduck is a static code analysis tool that has some code improvement tools. It can change your code to be more efficient but it doesn't change how VBA works.
Your question sounds like a good candidate for a StackOverflow question. I would recommend to describe exactly what you are attempting to achieve and not just this question as it is. The beauty of VBA is that you don't need to manage memory manually. If you don't explain what you are doing in great detail you are likely to get answ