title: How to Create Subarray Efficiently in VBA?
body: <p>In my VBA program, I have a big array of data, where I need to constantly use its sub-arrays.</p>
  
  <p>My method is:</p>
  
  <pre><code>Redim subArr(rowBegin to rowEnd)
  For r = rowBegin to rowEnd
      subArr(r) = bigArr(r)
  Next r
  </code></pre>
  
  <p>Is there any more efficient way to reference this kind of sub-arrays please? Thanks...</p>