ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Memory leak (https://www.excelbanter.com/excel-programming/403218-memory-leak.html)

Charlie

Memory leak
 
Is there a way to tell if you code is 'leaking memory'? Once in awhile it has
trouble and has to close excel... :(

Gary''s Student

Memory leak
 
VBA is not usually subject to leaking memory. Just make sure that you set
objects to Nothing when you are through with them.
--
Gary''s Student - gsnu200762


"Charlie" wrote:

Is there a way to tell if you code is 'leaking memory'? Once in awhile it has
trouble and has to close excel... :(


Charlie

Memory leak
 
I think I discovered that the problem was my code running w/break and then
trying to close Excel...

"Gary''s Student" wrote:

VBA is not usually subject to leaking memory. Just make sure that you set
objects to Nothing when you are through with them.
--
Gary''s Student - gsnu200762


"Charlie" wrote:

Is there a way to tell if you code is 'leaking memory'? Once in awhile it has
trouble and has to close excel... :(



All times are GMT +1. The time now is 01:19 AM.

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