looping through a worksheet range using a For/Next loop. : Cells « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Cells

looping through a worksheet range using a For/Next loop.

 
Sub NestedFor()
    Dim I As Integer
    Dim J As Integer
    
    For I = 1 To 10
        For J = 4 To 7
            Cells(I, Chr(J + 64)).Value = I * J
        Next J
    Next I
End Sub








Related examples in the same category

1.Select entire sheet
2.Set cell value with For Loop
3.Use row and column index to reference cell
4.Cells(Rows.Count, "A").End(xlUp).Select
5.Cells.Find: Get Real Last Cell
6.Get cell value
7.Sum Cells Based on the Interior Color
8.Entering a value in the next empty cell
9.Use the AutoFill function by specifying the destination range
10.Using Replace Programmatically to Set the Correct Range
11.Calling CurrentRegion to Inspect a List's Useful Characteristics