About Excel Macro Mastery

---

Welcome to my Excel VBA Channel. My name is Paul Kelly(Microsoft MVP) and I'm here to teach you how to write Excel VBA for the real world.

This channel will teach you proven techniques and little-known secrets about Excel VBA. These are techniques and secrets that I have used myself for over 20 years as a professional software developer.

In these videos, I break down complex Excel VBA topics in simple terms. I explain each part with code examples. Then I show you how to put it all together with real-world coding examples.

You can check out free articles on my Excel VBA website. This website receives well over one million visitors a year.
https://excelmacromastery.com/vba-articles/

I currently have the following training available:
☛ The Excel VBA Handbook course: https://theexcelvbahandbook.com/
☛ The VBA Vault Membership: https://excelmacromastery.com/excel-vba-webinars/

How to Return from a Function in 2 Minutes

How to Return from a Function in 2 Minutes In this video I cover how to return a value, object or array from a function in VBA. Returning these three items have slight differences so it is important to understand how each works. #vbafunction #vbareturn #vbareturncollection #vbareturnvalue …

---

The Easiest Way to Scrape Web Data with VBA

The Easiest Way to Scrape Web Data with VBA In this video I show you how to scrape data using a little-known method. The method is powerful because it only requires a few lines of code and doesn't require any installation or browser. SUBSCRIBE TO THE CHANNEL: https://bit.ly/36hpTCY DOWNLOA…

---

Master VBA Debugging in 20 Minutes

Master VBA Debugging in 20 Minutes In this video, I'm going to cover everything you need to know about Debugging in VBA. * What is debugging and why you need it. * When to use the Locals window and when to use the Watch Window. * The SandBox Method * Putting it all together - a real-world exampl…

---