Forcing Garbage Collection

Question

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

Answer 1

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