Can't add "=" before Cells.Value equation [VBA] 1004 Error

[benbreaker2000]

I have a dynamic equation that is filling across multiple cells, so until the equation is completely generate, I have not included the "=" sign at the beginning. I thought adding it would be as simple as Cells(i,j).Value = "=" & Cells.Value, but this does not work. I have tried the same thing similarly with Range.Value, Cell.Formula, and Range.Formula. It always returns a Runtime Error 1004, Application/ Object-Defined Error. Does anyone have any creative solutions for taking the cell value and adding a "=" to convert it to an equation?

 

[MARK858]

What happens with

Cells(i,j).[COLOR="#FF0000"]Formula[/COLOR]

rather than

Cells(i,j).Value

 

[RoryA]

Welcome to the forum.

Can you give an example of the exact contents of a cell that fails?

 

[jmacleary]

Try :

Cells(i,j).Formula = "=" & Cells(i,j).Text

I have tested this with a simple formula. The formula I used read: sum(D2:D15)