The Cells property is best suited for use with loops because it accepts numerical parameters representing the row and column indices in a worksheet : Cell Reference « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Cell Reference

The Cells property is best suited for use with loops because it accepts numerical parameters representing the row and column indices in a worksheet

 
Sub cellPro()
    Dim I As Integer
    Dim K As Integer
    For K = 1 To 5
        For I = 1 To 10
            Cells(I, K).Value = I * K
        Next I
    Next K
End Sub








Related examples in the same category

1.A1 Style References
2.Write a formula in the first 10 columns of row 21 in a worksheet that calculates the standard deviation of the values in rows 2 through 20
3.Entering A1 Versus R1C1 in VBA
4.R1C1 Style
5.R1C1 Style References
6.Use loop to select cells