Mastering Excel Macros: Object Variables (Book 6)

This lesson is a big step. You will learn about object variables. These are variables that are not numbers, not text but entire objects (worksheets, workbooks, etc.) that you can create and then manipulate as needed. In the follow along workbook in this lesson, you will have a list of customers and write a macro that will create a new invoice, in a new workbook, for each customer.

As with all the other lessons, there is a sample workbook you can get from my website to follow along with the exercises.