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

--
Don Guillett
SalesAid Software

"Gary''s Student" wrote in message
...
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

--
Gary's Student
gsnu200705