Set cell value with For Loop : Cells « Excel « VBA / Excel / Access / Word






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

Set cell value with For Loop

 
Sub RangeObjects()
   Dim i As Integer, j As Integer
   For i = 1 To 10
      For j = 1 To 5
         Cells(i, j).Value = i * j
      Next j
   Next i
End Sub








Related examples in the same category

1.Select entire sheet
2.Use row and column index to reference cell
3.Cells(Rows.Count, "A").End(xlUp).Select
4.looping through a worksheet range using a For/Next loop.
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