Referencing a text formula

[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 :

 

[Frank Kabel]

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

 

[Aladin Akyurek]

If you install the free morefunc.xll add-in
(http://longre.free.fr/english/index.html), you can have:

=EVAL(D7)

in D12.

 

[Dale_T]

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

 

[Frank Kabel]

Hi
I'd suggest taking a look at the following link to get started with
macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Aladin Akyurek]

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.

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