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???
Bookmarks