title: Fill array with consecutive integers
body: <p>I'm trying to fill an array with consecutive integers using Excel and VBA to pass to the Subtotal function. I need a dynamically sized array of consecutive ints. The fnction works when I use Array(1,2,3,4,5) for example, but not if I try to use a dynamically sized array.</p>
  
  <p>I've read some articles on this but none actually worked - has anyone else tried this?</p>