Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

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