Referencing a text formula

  • Thread starter Thread starter Dale_T
  • Start date Start date
D

Dale_T

Greeting Earthlings!

A simple question, to start out with:


Assume that cell D7 contains the text string "A1 * A4"

Is there a way that I can go to, say, D12, call the formula that'
in D7 and get the result of A1*A4?


It *seems* like you should be able to, but I haven't sorted it ou
yet.

BTW: The real formulae are a tad more complex than A1*A4

Wonko the Sane :
 
Hi
one idea would be the use of the following UDF:
Function make_formula(rng As Range)
If rng.Cells.Count > 1 Then
make_formula = False
Exit Function
End If
make_formula = Application.Evaluate(rng.Value)
End Function

you can call this as follows:
=make_formula(D7)

Note: Only tested for simple functions. Not sure why you want to use
this kind of function
 
Frank,

I like the UDF idea, but I'm not certain how to implement it


Aladin,

I did d/l your xll and it works great, but it certainly seems t
add to my memory overhead! Either that, or something else I've adde
is sure slowing down my machine.


Dal
 
I did d/l your xll and it works great, but it certainly seems to
add to my memory overhead! Either that, or something else I've added
is sure slowing down my machine.
Click to expand...

Dale,

Morefunc functions are fast. If you experience a slow down, have a look at
Charles Williams's site for diagnosis and tips:

http://www.decisionmodels.com/

Aladin
 
Back
Top