by Paul Kelly | | Data Structures VBA, Vault Video
Webinar Number: W0066 Arrays are possibly the most important element of Excel VBA. Not only do they make your code more readable, they also allow you to process data thousands of times faster than using Ranges. If you haven’t used arrays before, then they...
by Paul Kelly | | Data Structures VBA, Vault Video
Webinar Number: W0062 Arrays are possibly the most important element of Excel VBA. Not only do they make your code more readable, they also allow the you to process data thousands of times faster than using Ranges. If you haven’t used arrays before then you may...
by Paul Kelly | | Data Structures VBA, Vault Video
Webinar Number: W0047 This webinar features: Live Coding – The only Excel VBA Webinar where code is written in real-time. A real-world example of using the Dictionary. What is the Dictionary and why do you need it? Why pros prefer the Dictionary to the...
by Paul Kelly | | Data Structures VBA, Most Popular, Vault Video
Webinar Number: W0038 Arrays have been an important part of programming languages for a long time. In Excel VBA they are even more important as they have many important uses. The most powerful being when it comes to speeding up your VBA code exponentially. This...
by Paul Kelly | | Data Structures VBA, Most Popular, Vault Video
Webinar Number: W0037 It’s the start of a brand new year. And what better way to kick it off than with a live webinar on one of the most useful elements in VBA – The Excel VBA Dictionary. This webinar features: * The only VBA Webinar with Live Coding. * A...
by Paul Kelly | | Data Structures VBA, Vault Video
Webinar Number: W0036 If you have used the Collection in VBA then you may have noticed that it is severely limited. You cannot sort, check if an item exists write directly to a range and so on. What is there was an alternative to the Collection that had all these...