You can specify a cell or range of cells in one statement that identifies the range and also changes a property or applies a method.
A Range object in Visual Basic can be either a single cell or a range of cells. The following topics show the most common ways to identify and work with Range objects.
Some ways to reference cells
- Refer to all the cells on the worksheet
- Refer to cells and ranges by using A1 notation
- Refer to cells by using a Range object
- Refer to cells by using index numbers
- Refer to cells by using shortcut notation
- Refer to cells relative to other cells
- Refer to multiple ranges
- Refer to named ranges
- Refer to rows and columns
!include[Support and feedback]