title: Why use arrays in VBA when there are collections?
body: <p>many people use extensively arrays in Excel/VBA to store a list of data. However, there is the collection object which in my view is MUCH MUCH more convenient (mainly: don't need to re/define length of the list).</p>
  
  <p>So, I am sincerely <strong>asking myself if I am missing something?</strong> Why do other people still use arrays to store a list of data? Is it simply a hangover of the past?</p>