␡
- The Range Object
- Syntax to Specify a Range
- Named Ranges
- 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
- Use the Areas Collection to Return a Noncontiguous Range
- Referencing Tables
- Next Steps
From the author of
Shortcut for Referencing Ranges
A shortcut is available when referencing ranges. The shortcut uses 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] |