Hi,

Click on cell A1 and then go to Insert Name Define. Give it a name
called array. In the formula, enter =EVALUATE(Sheet1!$A$1). in A2, enter
=sum(array).

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Dave" wrote in message
...
Depending of the data in the spreadsheet, I need to change the formula in
a
cell. I'm trying to find an excel function that will evaluate the
resulting
text in a cell sort of like the INDIRECT() function does but one that will
work on formulas. I'm trying to use a formula in a cell to create a text
string that I then want evaluated. I.e.; a formula in cell A1 creates a
text
string with a formula "=B2*C2". I'm looking for a function that will
evaluate
that string. I thought this function was in excel but I can't find it.