So, in keeping with my promise to myself that I would be more active in posting blogs and videos this year, I've just uploaded another great new video to my YouTube channel!
This one is special, as it's the first lecture I recorded in response to a student question in the VBA part of the course (Excel Essentials Level 3 - VBA Programming)
All the code is there on the screen for anyone to use, free, gratis, and for no charge :) Though I hope it will guide some of you to get the course...you should, it's really useful.
20,000 lines of data processed in just over 1 second! That's how fast this code runs :)
This is a lecture I created for a student who asked if it was possible to collect a massive amount of data into an array, but then ignore any bits of data in an exclusion list, and return everything else...simple, and did I mention this code will process 20,000 lines of data in 1 second?
Okay, you will find the full VBA code here, with a complete walkthrough of what each line does.