I am looping through a set of data to find two specific points. I save the row# as integer variables x and z. I then want to calculate the standard deviation of a column if values begining with row x and ending with row z. I tried using the FormulaR1C1 as:
Range("J4").Select
ActiveCell.FormulaR1C1 = "=STDEV(R[x]C[36]:R[z]C[36])"
Where I am storing the result from the calculation in cell J4.
What am I doing wrong?
Thanks
Range("J4").Select
ActiveCell.FormulaR1C1 = "=STDEV(R[x]C[36]:R[z]C[36])"
Where I am storing the result from the calculation in cell J4.
What am I doing wrong?
Thanks