Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. The Cells property is best suited for use with loops because it accepts numerical parameters representing the row and column indices
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