Reference cells and ranges

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.