ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Memory Management in VBA (https://www.excelbanter.com/excel-programming/428846-memory-management-vba.html)

GM

Memory Management in VBA
 
hi,
Is there any way to flush the memory in VBA?
I know the use of nothing, which has been already incorporated in my code.
any thing on application object?

Thanks,
GM

Patrick Molloy

Memory Management in VBA
 
if you have created objects, release them by setting to nothing

eg

SET xyzObject = NOTHING



"GM" wrote in message
...
hi,
Is there any way to flush the memory in VBA?
I know the use of nothing, which has been already incorporated in my code.
any thing on application object?

Thanks,
GM




All times are GMT +1. The time now is 04:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com