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])"