Hello,
with this Code:
_Cells[_Rowcount, _ColumnEnd].Formula = "=SUMPRODUCT(D30:D152;1/(1-F30:F152);E30:E152)/SUMPRODUCT(D30:D152;1/(1-F30:F152))";
I've got the error:
Exception message: Error in Cell: D19-Invalid formula:"=SUMPRODUCT(D30:D152;1/(1-F30:F152);E30:E152)/SUMPRODUCT(D30:D152;1/(1-F30:F152))".
I have tried ths form in Excel and the it works fine
thanks
Christian