cells.value vs cells.formula

[lezawang]

Hi
In this code, I do not see any difference between cell.value and cells.formula when it comes to entering a formula.
They both did the same thing. Am I right? Is there any case, I have to use cells.formula instead of cells.value? Thank you very much.

Sub insert_formula()
    Cells(11, 1).Value = "=sum(a1:a10)"
    Cells(12, 1).Formula = "=sum(a1:a10)"
End Sub

 

[Fluff]

They both work like that, however I would always use Formula when entering a formula & Value when entering a value, as I find it far more obvious what is going on, when revisiting the code at some point in the future.

 

[Fluff]

Another point, if you use .Formula & in 2 years someone asks you to change the formula, you can search for .Formula & quickly find the formula to change.
Whereas if you use .Value it will take a lot longer.