Reference function name from a different cell
Thanks Pete!
"Pete_UK" wrote:
There is an Evaluate function available in VBA which takes a string
that looks like an Excel formula (e.g. "=SUM(B1:B10)") and evaluates
it. This can easily be incorporated in a simple user-defined formula
(often called Eval - do a Google search for this), which would then
allow you to type:
=Eval(A1)
and if A1 contained the string the result will be the result of the
"string" formula.
Not exactly what you asked for, but it could easily be modified to
suit your situation.
Hope this helps.
Pete
On Jul 24, 7:32 pm, BryanDamon
wrote:
I am trying to do something like this
=A1(B1:B10)
where A1=sum (or some function)
So I want excel to know the text value in A1 as the function name. Is this
possible?
|