Software

Ask something
Question Locked

writing FormulaR1C1 with $

0 helpful
2 replies

by talark81

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In VBA Excel how we can write the following formula =SUM($A$1:$A$10 programatically by using the FormulaR1C1 ?
ex: ActiveCell.FormulaR1C1 = "=RC[-1]/R[1]C[-1]" ?

2 replies

by hugo.du

ActiveCell.FormulaR1C1 = "=SUM(R1C1:R10C1)"

This discussion is closed to new replies.