You may use fixed column to start - I assume column 2:
![]()
Cells(4, lCounter + 2).FormulaR1C1 = "=AVERAGE(RC2:RC[-1])" Cells(4, lCounter + 3).FormulaR1C1 = "=STDEV(RC2:RC[-2])"
You may use fixed column to start - I assume column 2:
![]()
Cells(4, lCounter + 2).FormulaR1C1 = "=AVERAGE(RC2:RC[-1])" Cells(4, lCounter + 3).FormulaR1C1 = "=STDEV(RC2:RC[-2])"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks