title: How to initialize a multidimensional array variable in vba for excel
body: <p>The <a href="http://msdn.microsoft.com/en-us/library/y13tek7e.aspx" rel="noreferrer">Microsoft site</a> suggests the following code should work:</p>
  
  <p><code>Dim numbers = {{1, 2}, {3, 4}, {5, 6}}</code></p>
  
  <p>However I get a complile error when I try to use it in an excel VBA module.
  The  following does work for a 1D array:</p>
  
  <p><code>A = Array(1, 2, 3, 4, 5)</code></p>
  
  <p>However I have not managed to find a way of doing the same for a 2D array.
  Any ideas?</p>