title: Excel 2007 VBA Array Size Limit
body: <p>Numerous sources I have found have suggested that the size of arrays for VBA code depends upon the amount of memory in the machine. This however hasn't been the case for me. I'm running the following, very simple, code to test:</p>
  
  <pre><code>Sub test6()
  Dim arr(500, 500, 500) As Boolean
  End Sub
  </code></pre>
  
  <p>However, if I change the size to be 600x600x600, I get an out of memory error. The machine I'm using has 16Gb of RAM, so I doubt that physical RAM is the issue.</p>
  
  <p>I'm using Excel 2007. Is there a trick to getting VBA to use more RAM?</p>