VBA and Macros for Microsoft Excel

3Referring to Ranges

IN THIS CHAPTER

The Range Object

Using the Top-Left and Bottom-Right Corners of a Selection to Specify a Range

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 Quickly Select a Data Range

Case Study

Using the Areas Collection to Return a Non-contiguous Range

Next Steps