by Paul Kelly | | Building Applications, Vault Video
Webinar Number: W0057 This webinar features: What are arrays and why do you need them? 100x your code speed by using arrays instead of ranges How to read through arrays How to copy arrays How to avoid the pitfalls that catch many array newbies out How to create...
by Paul Kelly | | Building Applications, Vault Video
Webinar Number: W0056 This webinar features: Real-world code examples. What is the Dictionary and why do you need it? Practical uses of the dictionary. How to write the Dictionary keys and items to a Range without a loop How to easily fix any issue with the Dictionary...
by Paul Kelly | | Building Applications, Vault Video
Webinar Number: W0055 This webinar features: Learn a system for building Excel VBA applications. How anyone can get started creating an Excel VBA application How to easily design your application without the need for complex tools or methods A technique for testing...
by Paul Kelly | | Copying Data, Vault Video
Webinar Number: W0050 This webinar features: Live Excel VBA Coding A simple guide that will help you select the correct worksheet every time How to decide which workbook should contain the code How to copy data on the same worksheet How to copy to or from a closed...
by Paul Kelly | | Building Applications, Intermediate VBA, Vault Video
Webinar Number: W0049 This webinar features: Live Excel VBA Coding What is clean code? The 3 major advantages of writing clean code. 5 ways to make your code clean – it’s not hard once you know the secret. A simple method that will make your code ten times...