The Big Three

In module 6 we look at The Big Three:

• Workbooks
• Worksheets
• Ranges

These are very important building blocks for you to learn about.

When you program in Excel you are going to be working with workbooks, worksheets and ranges most of the time.

---

The PDF Handout

I prepared a special PDF Handout for you.

It has hyperlinks that take you to each section and back to the table of contents.

The PDF is organized in the same order as the video lessons.

It is great as a quick reference guide.

Download the PDF Handout and VBA Workbooks – you will need to refer to these when you work on the projects.

The PDF is useful reference guide with information and code samples covering Workbooks, Worksheets and Ranges. Keep it handy on your desktop.

---

Focus on the projects

The most important part of this module is practice. The projects are especially important here.

I created a mix of useful and fun projects for you. By working on the projects you are going to start building your abilities as a budding VBA programmer.

---

How to complete Module 6

This is how you should approach this module.

• Watch the videos
• Do the quizzes (both are very short)
• Work on the projects

And remember to have fun with the projects!

Write your comments and feedback below

• If you have questions or comments about this lesson, write it in the section below.
• Alternatively you can email the instructor Victor at [email protected]