Application defined or object defined error

[dpaton05]

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" & .Rows.Count).End(xlUp).Row).Formula = "=RC[-1]+RC[-2])"

What else do I need to do?

 

[dpaton05]

Found the error, I had an extra bracket.