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.
Read MoreFeatured Posts
Recent Posts
Inflation Over Multiple Years in a Single Cell January 10, 2025
Hubspot Dashboard October 3, 2024
Monthly Dashboard With Supporting Metrics September 25, 2024
Excel Show Missing Sheet Tabs July 29, 2024
Run Macro Overnight Automatically June 24, 2024
Split File into Parts and Save to Directory April 20, 2024
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