Sheets("Scenario").Range("B" & k).Formula = "=SUM(Summary!"O"&k:"BJ"&k)"

Where k is an Integer variable. (For testing purpose I just made k=4.)

I keep getting various errors with this line such as "expected end of statement" or "syntax error" or "expected )"

Please help