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.

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 ...

Get Mastering VBA for Microsoft Office 365, 2019th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.