3. Referring to Ranges
In This Chapter
Shortcut for Referencing Ranges
Referencing Ranges in Other Sheets
Referencing a Range Relative to Another Range
Use the Cells Property to Select a Range
Use the Offset Property to Refer to a Range
Use the Resize Property to Change the Size of a Range
Use the Columns and Rows Properties to Specify a Range
Use the Union Method to Join Multiple Ranges
Use the Intersect Method to Create a New Range from Overlapping Ranges
Use the ISEMPTY Function to Check Whether a Cell Is Empty
Use the CurrentRegion Property to Select a Data Range
A range can be a cell, a row, a column, ...
Get Excel® 2013 VBA and Macros 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.
