Nest a referenced formula in excel

[roryl@atomicaudio.net]

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

[Miguel Zapico]

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

"roryl@atomicaudio.net" wrote:

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