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, ...

I've seen lots of different ways to get around VBA's lack of Constant Arrays. But I wanted something that looks, at least somewhat, like a table and doesn't have to be pre-populated like a ...

I'm trying to load a database into a 2D array and not having any luck. I've been working off snippets of code I've found here and there so I may be doing it all wrong. I can grab multiple fields from ...