Transfer Data Between Arrays with VBA
Transfer data in a VBA range into an array and then output part of the array into another array. Push the information back into Excel seamlessly.
Read MoreFilter 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.
Read MoreFeatured Posts
Recent Posts
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
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