title: How can I "ReDim Preserve" a 2D Array in Excel 2007 VBA so that I can add rows, not columns, to the array?
body: <p>I'm working with a dynamic array in Excel VBA.  The number of columns (m) is fixed, however, I do not know how many rows (n) will be required.</p>
  
  <p>The help documents state that ReDim Preserve myArray(n, m) allows me to make m larger, but not n.  However, I need to increase the number of rows (n) while preserving my data, not columns (m)!</p>
  
  <p>For example, I may have a (5,20) array that I would like to expand to (10,20) while preserving my data. </p>
  
  <p>It seems that if there were some way to transpose my array, do a ReDim Preserve to expand the number of "columns", then re-transpose my array, I could accomplish what I want.</p>
  
  <p>Is this the correct way to do this?  If so, how can I do that?</p>
  
  <p>Is there a better way to accomplish what I want?</p>