Protect a Worksheet, Use the Autofilter

Protect an Excel worksheet and use the auto filter. A how to guide.

Tags auto, filter, protect, worksheet, excel, Protect

Excel VBA Filter by Icon Sets

Excel has been improving the autofiltering capabilities and this single topic forms the topic which I have happened upon the most. I am probably like a lot of developers who had their eyes opened by the Excel loop through a range when you set criteria and Excel does the isolation for you. The problem with this method occurs when you need to loop through thousands of rows. This can slow your procedure considerably. Using the autofilter with VBA by contrast is very quick and the time difference between a small list and a large list is negligible. More recently Excel has introduced the ability to filter by icon sets. The conditional formatting coloured arrows or chart indicators which appear in cell.

Tags Excel, VBA, Icon sets, formatting, conditional, autofilter, filter

Excel VBA Autofilter on Multiple Criteria

Anyone who has followed my posts on Ozgrid or Chandoo forum will have noticed how frequently I use the autofilter in favour of any kind of loop. I have been lead to believe that in some instances that arrays will perform faster than the humble autofilter however for brevity of code and swiftness I really like the simple elegance of the autofilter. In the article Autofilter on Multiple Conditions I delved into the world of the filer using more than one criteria.

Tags Exce, VB, Autofilter, filter, Multiple, criteria

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