My function is not setting the range specified

Brass Contributor

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


1 Reply
best response confirmed by rodsan724 (Brass Contributor)
1 best response

Accepted Solutions