How to: Reference Cells and Ranges
|Excel Developer Reference|
A common task when using Visual Basic is to specify a cell or range of cells and then do something with it, such as enter a formula or change the format. You can usually do this 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
- How to: Refer to All the Cells on the Worksheet
- How to: Refer to Cells and Ranges by Using A1 Notation
- How to: Refer to Rows and Columns
- How to: Refer to Cells by Using Index Numbers
- How to: Refer to Cells by Using Shortcut Notation
- How to: Refer to Cells Relative to Other Cells
- How to: Refer to Cells by Using a Range Object
- How to: Refer to Named Ranges
- How to: Refer to Multiple Ranges