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 Multiple Ranges
See Also