I would like to set formula that includes a string variable in VBA. The
following
code caused "Runtime error 1004 Application-defined or Object-defined error"

dim strRow_Number as String
strRow_Number = "100"

ActiveCell.FormulaR1C1 = "=SUM(R[1]C[-2]:R[" & strRow_Number & "]C[-2])"

How can I set the formula with variables???