Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Referring to Cells by Using Index Numbers [Excel 2003 VBA Language Reference]

You can use the Cells property to refer to a single cell by using row and column index numbers. This property returns a Range object that represents a single cell. In the following example, Cells(6,1) returns cell A6 on Sheet1. The Value property is then set to 10.

Sub EnterValue()
    Worksheets("Sheet1").Cells(6, 1).Value = 10
End Sub

The Cells property works well for looping through a range of cells, because you can substitute variables for the index numbers, as shown in the following example.

Sub CycleThrough()
    Dim Counter As Integer
    For Counter = 1 To 20
        Worksheets("Sheet1").Cells(Counter, 3).Value = Counter
    Next Counter
End Sub

Note  If you want to change the properties of or apply a method to a range of cells all at once, use the Range property. For more information, see Referring to cells using A1 notation.

© 2015 Microsoft