title: Excel VBA: Does destroying a collection of objects destroy every single object?
body: <p>Say I have a collection <code>MyCollection</code> of objects of <code>MyClass</code>. </p>
  
  <p>Does <code>Set MyCollection = Nothing</code> call each contained object's destructor or should I take care of setting each object <code>= Nothing</code> individually? </p>
  
  <p>I obviously care for reasons of memory leakage.</p>
  
  <pre><code>Dim MyCollection As Collection
  Set MyCollection = New Collection
  ... 'add objects of type MyClass here
  Set MyCollection = Nothing 
  </code></pre>
  
  <p><strong>Does destroying this class call every single object's destructor?</strong></p>