Chapter 22
Understanding 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 actions with the most immediately 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:
- 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
It’s not crucial to understand how the Excel object model fits together in order to work with VBA in Excel, but most people find that ...
Get Mastering VBA for Microsoft Office 2007, 2nd 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.
