title: Adding an element to the end of an array in VBA
body: <p>Q&amp;A:
  How can one add an element to a the end of a (dynamic) array in VBA? </p>
  
  <p>This same question was for a list in stead of an array:
  <a href="https://stackoverflow.com/questions/42622231/adding-an-element-to-variant-list-array-in-vba">Adding an element to variant list/array in VBA</a>
  This same question was about redimensioning arrays with 2 dimensions:
  <a href="https://stackoverflow.com/questions/19855289/rediming-an-array-in-vba">ReDiming an array in VBA</a>
  This same question did not ask for the general simple case:  <a href="https://superuser.com/questions/808798/adding-an-element-to-the-end-of-an-array">https://superuser.com/questions/808798/adding-an-element-to-the-end-of-an-array</a></p>