I had this line of code in my spreadsheet and it worked, it just printed the formula in the cell.
.Range("J" & .Range("J" & .Rows.Count).End(xlUp).Row).Formula = "RC[-1]+RC[-2])"
All I did was add = before the RC and it gave me an error.
.Range("J" & .Range("J" &...