Microsoft Office Tutorials and References
In Depth Information
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.