title: Excel VBA Appending data to single Array
body: <p>Am trying to parse an excel file using Excel VBA.</p>
  
  <p>Here is the sample sata
  <img src="https://i.stack.imgur.com/tpFbB.jpg" alt="enter image description here"></p>
  
  <p>I did some research and found you can assign ranges to array like </p>
  
  <pre><code>Arrayname = Range("A1:D200")
  </code></pre>
  
  <p>But am looking for some thing more dynamic, like add the below multiple ranges to a single array.
  and my final array will be a single array/table with n is number of rows from all ranges and 4 columns.</p>
  
  <p>Can any one please prvide me a example.
  Thank you in adavance.</p>