Chapter 7: Working with Ranges
Ranges are used in Excel because Excel is all about cells, and the Range object is a container for cells. Without a solid understanding of ranges, working in Excel is virtually impossible. It's all about moving around on the spreadsheet, assigning values, changing properties, and using methods. Although less important in Word and PowerPoint, the principles of working with ranges are still essential.
In this chapter, we will cover the following recipes:
- Referring to ranges
- Using the
Rangeobject properties - Adding the
Rangeobject's methods - Making ranges work
By the end of this chapter, you will be able to work effectively with ranges in VBA.
