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.
Read MoreFeatured Posts
Recent Posts
Most Popular Author December 14, 2023
Creating an Excel Dashboard - A Guide with Templates December 8, 2023
Real Estate Excel Dashboard October 11, 2023
Updating Excel Dashboards September 29, 2023
TheSmallman in Another Top Blog Rank April 24, 2023
Project Tracking Dashboard March 25, 2023
Excel Unique Formula September 17, 2022
Horizontal Range to Vertical Range in Excel June 15, 2022
Hiding Rows Quickly with VBA May 20, 2022
Cascading Combo Boxes 3 and 4 Layer April 24, 2022