How do I clean up memory in Excel VBA? I've tried setting objects to "Nothing" but I get an error stating that this is an invalid use of an object.
My VBA Macro calls a third party API which returns numerous strings that are huge in size. The Excel workbook end up taking up 60-80 mb of RAM. How can I get excel to release all objects?