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 do the following:
Work with workbooks
Work with worksheets
Work with the active cell or selection
Work with ranges
It's not crucial to understand how the entire Excel object model fits together in order to work with VBA in Excel, but most people ...