.formula in vba

[tibetors]

Hi guys, I am trying to take the difference of two cells using a formula, but could not get it to work. Could you tell me what's wrong with my code?

Sheets("RAPOR").Cells(x, 5).Formula = "=" & Cells(x, 3).Address&"-"&Cells(x, 3).Address

When I run it, I get an error saying "Expected end statement."

Thanks!

 

[Domenic]

Try adding a space before and after the ampersand...

Sheets("RAPOR").Cells(x, 5).Formula = "=" & Cells(x, 3).Address & "-" & Cells(x, 3).Address

Although, it looks like you're referencing the same cell.