Page 216 - Microsoft Office Excel 2003 Programming Inside Out

Part 3: The Excel Object Model
Microsoft Office Excel 2003 Programming Inside Out

In this chapter, you’ve learned how to refer to and manipulate ranges and individual cells in
your worksheets. The fundamental concept to remember is that, while you can refer to indi­
vidual cells within a range, even single cells are called using the Range object (for example,
Range("A16"). Once you’ve specified the range you want to work with, you can use the
range’s values in formulas, define a name to allow more streamlined and user friendly refer­
ences to the range, and validate the data entered into the range.

Chapter 8

190