Microsoft® Office Excel 2003 Programming Inside Out

Chapter 8. Ranges and Cells

Basic Range Manipulations

Referring to Ranges

Manipulating Groups of Cells

Using Named Ranges

Getting Data Entry Right the First Time

Before any work can be done with the information inside a workbook, you need to be able to access it. You’ve already looked at accessing the larger elements of the Excel Object Model, namely the Microsoft Excel application itself and workbooks and worksheets. In this chapter, you will learn how to work with cells and ranges of cells.

Basic Range Manipulations

A cell is the basic working unit inside an Excel worksheet, but within the Excel Object Model, a Range object is the basic working unit. You use a Range object to work with either groups of cells or an individual cell.

Finding the Active ...