SUMPRODUCT in VBA

[Guest_imported]

My formula is the following but Vb doesnt accept it; I don't find the mistake

Activecell.FormulaR1C1 = "=SUMPRODUCT((R[+" & nbrLign & "]C:R[+1]C);(R[+" & nbrLign & "]C[-1]:R[+1]C[-1]))"

 

[rmikesmith]

wo,

Try replacing the semi-colon ( with a colon ). This is the correction Excel makes to your formula (when typed in directly to the worksheet):

Activecell.FormulaR1C1 = "=SUMPRODUCT((R[+" & nbrLign & "]C:R[+1]C):(R[+" & nbrLign & "]C[-1]:R[+1]C[-1]))"


HTH
M. Smith