Transfer Data Between Arrays with VBA

Transfer data in a VBA range into an array and then output part of the array into another array. Push the information back into Excel seamlessly.

Tags Excel, Array, Transfer, data

Filter Data in VBA without an Excel Filter

In Excel VBA it is possible to apply a filter directly to items contained within an array. This method, little known, is a way of filtering without the more traditional auto filter. I have not conducted any tests but as the filter is performed in memory I assume the process happens more quickly than a regular Excel auto filter. This would make a nice Excel case study.

Tags filter, data, index, array, VBA