␡
- 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
This chapter is from the book
Shortcut for Referencing Ranges
A shortcut is available when referencing ranges. The shortcut involves using square brackets, as shown in Table 3.1.
Table 3.1 Shortcuts for Referencing Ranges
Standard Method |
Shortcut |
Range("D5") |
[D5] |
Range("A1:D5") |
[A1:D5] |
Range("A1:D5, G6:I17") |
[A1:D5, G6:I17] |
Range("MyRange") |
[MyRange] |