Mastering VBA for Microsoft Office 2016

Chapter 22Understanding the Excel Object Model and Key Objects

This chapter shows you how to start working with the Excel object model, the architecture underlying Excel. It also shows you how to perform common tasks with the most frequently useful Excel objects. These objects include the Workbooks collection and the Workbook object, the ActiveCell object, and Range objects. You'll also see how to set options in Excel.

In this chapter, you will learn to do the following:

• Work with workbooks
• Work with worksheets
• Work with the active cell or selection
• Work with ranges
• Set options

Getting an Overview of the Excel Object Model

As with the other Office applications, it's not necessary (or even possible for most people) to understand how ...