Hi Tom,

You have posted a few questions about this instability. No-one reading can
really provide a comprehensive answer since we've got no understanding of
what you are doing. People can provide a few pointers but it's very hard to
help when you cannot see the code.

My "code unseen" tip - create a new workbook and cut and paste all of your
VBA into there then re-compile.


--
http://www.alignment-systems.com


"Tom Med" wrote:

I am having a lot of problems with VBA instability at the moment. And
I am pretty sure this is to do with the destruction of objects and
their deletion from memory. I get this instability everytime I try to
stop the VBA or to close certain workbooks. Does anyone have any
information or resources about how VBA manages it objects? Or does
anyone know what known problems there are with certain types of object
that could cause instabilities? Sort of like the C# problem with
structs vs classes. Are there certain things I should to to ensure
the clean removal of objects within classes?


Thanks
Tom