Refer to Cells and Ranges by Using A1 Notation
Refer to a cell or range of cells in the A1 reference style by using the Range property. The following subroutine changes the format of cells A1:D5 to bold.
Sub FormatRange()
Workbooks("Book1").Sheets("Sheet1").Range("A1:D5") _
.Font.Bold = True
End Sub
The following table illustrates some A1-style references using the Range property.
| Reference | Meaning |
|---|---|
Range("A1") |
Cell A1 |
Range("A1:B5") |
Cells A1 through B5 |
Range("C5:D9,G9:H16") |
A multiple-area selection |
Range("A:A") |
Column A |
Range("1:1") |
Row 1 |
Range("A:C") |
Columns A through C |
Range("1:5") |
Rows 1 through 5 |
Range("1:1,3:3,8:8") |
Rows 1, 3, and 8 |
Range("A:A,C:C,F:F") |
Columns A, C, and F |
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.