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 | | Most Popular, Vault Video
Webinar Number: W0046 This webinar features: * Excel VBA Coding * How to structure your code – it’s not hard once you know the secret. * How to get notified immediately when an error occurs – this idea alone will save your hours of wasted time. *...
by Paul Kelly | | Tips and Tricks, Vault Video
Webinar Number: W0045 In this webinar, I will show you 5 simples hacks that will help immensely with your VBA code. This webinar includes: Live Excel VBA Coding 5 Hacks that will make your life easier A little known function with massive ability A simple Watch Window...
by Paul Kelly | | Dealing with Errors, Vault Video
Webinar Number: W0044 This webinar provides a guide to using the Debugging tools in VBA. Most people know the debugging tools as a way to fix errors. But the biggest advantage of debugging is that you can see exactly what your code is doing. This webinar contains:...
by Paul Kelly | | Copying Data, Vault Video
Webinar Number: W0043 Back in May I ran a webinar on Advanced Filter and it was extremely popular. Advanced Filter is one of the best ways to copy and filter data using VBA. However, most people don’t know about it and end up using for Loops or some other...