Classes losing focus

[agibsonsw]

Hello.
If I have a public Collection and run a procedure that adds an instance of my class to this collection, when will the collection 'vanish'?

Can I continue to use Excel and add further instances to the collection? Will it disappear if I save the workbook or edit some code?
Thanks, Andy.

[HansV]

The collection will remain in memory until one of the following happens:

- The workbook containing the code is closed.
- You explicitly set the collection to Nothing.
- The code is reset; this happens when an unhandled error occurs, and usually also when you edit code.

[agibsonsw]

That's great, thanks.