Question posted 2009 ยท +4 upvotes
Is there a way to force garbage collection in VBA/Excel 2000?
This question refers to the Macro language in Excel. Not using VB .NET to manipulate Excel. So GC.collect() won’t work
Accepted answer +9 upvotes
You cannot take advantage of garbage collection provided by the .NET Framework when using straight VBA. Perhaps this article by Eric Lippert will be helpful
Top excel-vba Q&A (6)
- How to clear the entire array? +58 (2010)
- How to change Format of a Cell to Text using VBA +55 (2011)
- Download attachment from Outlook and Open in Excel +43 (2012)
- Can a VBA function in Excel return a range? +36 (2009)
- 2 Dimensional array from range +34 (2013)
- Hiding an Excel worksheet with VBA +33 (2009)
excel-vba solutions on this site
.