Strange VBA problem with Cells.Formula: evaluation results in error

[CedricMattelaer]

Dear all,

Can somebody tell me why

.Cells(592 + gameno + 32 * opponent, 22 + Hometeam).Formula = "= " & .Cells(592 + gameno + 32 * opponent, 22 + Hometeam).Formula & " + " & .Cells(646 + daysconcerned, 18).Value

results in an error? The error code is 1004: error defined by application or object

At first it worked fine, now the same problem returns all the time.
Strange thing is, if I remove the "=" & in the front (like in the code below), no error is returned.

.Cells(592 + gameno + 32 * opponent, 22 + Hometeam).Formula = .Cells(592 + gameno + 32 * opponent, 22 + Hometeam).Formula & " + " & .Cells(646 + daysconcerned, 18).Value

Can somebody help me? I tried already using .Value instead of .Formula (not really what I want but still possible to use) but the same error occurs.

Thanks a lot!

Cedric

 

[CedricMattelaer]

Also, if I go to the line before it and press "F8", no error is given.

Any ideas?

 

[CedricMattelaer]

As I found out what seems to be causing the problem, I posted a follow-up on this question on the following page: http://www.mrexcel.com/forum/showthread.php?t=593412