Hi,
Try using FormulaR1C1 instead. So you can use relative and/or absolute references.

Go in the cell where your formula is, then open the VBE editor immediate windows and type : Debug.Print ActiveCell.formulaR1c1
Use this result in your code :
Example : 

rngcell.formulaR1C1 = " the formula here... "