Use loop to select cells : Cell Reference « Excel « VBA / Excel / Access / Word






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

Use loop to select cells

 
Sub forDemo()
    Dim i As Integer
    For i = 1 To 24
        ActiveCell.FormulaR1C1 = i & ":00"
        ActiveCell.Offset(RowOffset:=1, ColumnOffset:=0).Select
    Next i
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.The Cells property is best suited for use with loops because it accepts numerical parameters representing the row and column indices in a worksheet
4.Entering A1 Versus R1C1 in VBA
5.R1C1 Style
6.R1C1 Style References