formatting — Blog — Excel Dashboards VBA and more

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.