Nest a referenced formula in excel

[roryl]

Hello,

Does anyone know a way to use a referenced cell (containing text) and
have the parent cell use that text in the formula?

As an example.

In A1 I have "B1+B2" (stored as text, not an equation)

Then I want to be able to have A2=A1, and have it actually compute the
equation (B1+B2) as if I had typed '=B1+B2' into A2

Thanks

 

[Guest]

You can use evaluate(), but not directly. Here is an example:
http://www.ozgrid.com/News/excel-evaluate-formula-VBA.htm