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