Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. 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 thro
Sub formulaDemo()
    Dim I As Integer
    For I = 1 To 10
           Cells(21, I).Formula = "=STDEV(" & Chr(I + 64) & "2:" & Chr(I + 64) & "20)"
    Next I
End Sub