Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

Chapter 3

Referring to ranges

In this chapter, you will:

• Learn how to reference the Range object

• Reference ranges in other sheets

• Reference 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

• Use the SpecialCells property to interact with specific cells in a range

• Use the Areas collection to return a noncontiguous range

• Learn the syntax used for ...