execute a text as a formula
 

Hi,

I have the following problem, but couldnt find an answer in google. May be
it is too simple.

I have a text in a cell, I wish to evaluate it as a formula. This text
itself is a result of a formula.

For eg.,

="=request(" & A1 & "," & A2 &")"

This formula would result in a text: =request("ABC","DEF")

I want excel to treat the result as the next formula and execute it ? Is
this possible ? How can I do it ?


Thanks.

execute a text as a formula
 

Hi
have a look at application.evaluate in the VBA help

Frank
-----Original Message-----
Hi,

I have the following problem, but couldnt find an answer
in google. May be
it is too simple.

I have a text in a cell, I wish to evaluate it as a
formula. This text
itself is a result of a formula.

For eg.,

="=request(" & A1 & "," & A2 &")"

This formula would result in a text: =request("ABC","DEF")

I want excel to treat the result as the next formula and
execute it ? Is
this possible ? How can I do it ?


Thanks.


.