Excel 2016 VBA and Macros

3. Referring to Ranges

In This Chapter

The Range Object

Syntax for Specifying a Range

Named Ranges

Shortcut for Referencing Ranges

Referencing Ranges in Other Sheets

Referencing a Range Relative to Another Range

Using the Cells Property to Select a Range

Using the Offset Property to Refer to a Range

Using the Resize Property to Change the Size of a Range

Using the Columns and Rows Properties to Specify a Range

Using the Union Method to Join Multiple Ranges

Using the Intersect Method to Create a New Range from Overlapping Ranges

Using the IsEmpty Function to Check Whether a Cell Is Empty

Using the CurrentRegion Property to Select a Data Range

Using the Areas Collection to Return a Noncontiguous Range

Referencing Tables

Next Steps

A range can ...