Error trying to add formula using VBA

[sharky12345]

I'm trying to add this formula to a cell using VBA but I'm getting an error, 1004 Application-defined or object-defined - I have no idea why if someone can explain please?

Cell.Offset(0, 2).Formula = "=" & Cell.Offset(0, -1).Address & "/" & Cell.Offset(0, -2).Address & ""

 

[RoryA]

Where is cell located?

 

[sharky12345]

Sorry, should have explained - this is the full code:

Application.ScreenUpdating = False

LastRow = Sheet10.Range("A65536").End(xlUp).Row
For Each Cell In Sheet10.Range("B2:B" & LastRow)

Cell.Offset(0, 2).Formula = "=" & Cell.Offset(0, -1).Address & " / " & Cell.Offset(0, -2).Address & ""

Next

Application.ScreenUpdating = True

 

[sharky12345]

Solved it:

Cell.Offset(0, 2).Formula = "=" & Cell.Offset(0, 1).Address & "/" & Cell.Address & ""

 

[RoryA]

That's what I suspected - can't really go two columns left from column B.