Filter Data in VBA without an Excel Filter

March 4, 2015
Marcus Small

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