[VB.NET] Inserting Relative formulas
 

Hi,

During the generation of Excel Documents with vb.net, I always get strange
errors who means nothing.
This happens every time at the moment I try to insert a relative formula.

Other functions (like inserting text, formulas like=sum(A1:B5), layout) are
going perfect.

Does somebody has a solution for me ?

These are some of my attempts:
Ws.Range(col & row).FormulaR1C1 = "(R[-8]C:R[-1]C)"
Ws.Range(col & row).FormulaR1C1 = "=SUM(R[-2]C:R[-1]C)"
App.Range(col & row).Formula = "=SUM(R[-2]C:R[-1]C)"
App.Range(col & row).FormulaR1C1 = "=R[-2]C+R[-1]C"
App.ActiveSheet.Cells(rij, 3).Formula = "=C[-1]+c12"


thx,