VBA has no tools for working with dynamic arrays. I propose a simulation of a two-dimensional dynamic array - based on the object: a one-dimensional array of one-dimensional arrays. Used ...

ArrayTools is a Project that allows easy data manipulation when working with Arrays and Collections in VBA (regardless of host Application). Operations like sorting, filtering, converting, reversing, ...

So, I am writing an application in Excel2000 and VBA. I am using Autofilter to go through a bunch of raw data in a worksheet, filter it out, and copy it to a new sheet. For example, I have a sheet ...