Export (0) Print
Expand All

How to: Reference Cells and Ranges

Office 2007

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



Community Additions

ADD
Show:
© 2014 Microsoft