any value to range.formula

[Guest]

Is there any advantage to setting a cell's contents using range.formula vs
range.value? The following yield identical results:


Sub place_it()
s = "=1+2"
Range("A1").Value = s
Range("A2").Formula = s
End Sub

 

[Don Guillett]

Except for clarity of what you are doing, apparently not but I often like to
just leave the value

Sub place_it()
s = "=1+2"
'Range("A1").Value = s
Range("a1").Value = Application.Sum(1, 2)
'or
Range("a1").Value = 1 + 2
Range("A2").Formula = s