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 Range object properties
- Adding the Range object's methods
- Making ranges work
By the end of this chapter, you will be able to work effectively with ranges in VBA.
Technical requirements
This cookbook was written and designed to be used ...
Get VBA Automation for Excel 2019 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.