My function is not setting the range specified

[rodsan724]

Why is the function below not setting value for A2 when I call from a cell. However, if I hit play in the VBA editor it works.

Public Function RsTest() As String
    Range("A2").Value = "not working"
    RsTest = "test"
End Function

[#2 · Accepted solution]

https://stackoverflow.com/questions/15659779/set-a-cell-value-from-a-function