Thread: Indirectly refer to function

I'm trying to call a function that is stored in a cell as a text string.

In cell A1, I have the text Sum('Sheet1:Sheet3'!C3). I want to call this function from a different cell. Is this possible using the pre-defined functions, or would I be better creating my own function?

This will attempt to resolve the text in the cell noted:

Code:

Public Function ResolveText(Rng As Range)
    ResolveText = Evaluate(Rng.Text)
End Function

Used as
=RESOLVETEXT(A1)

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)