Thank you, Ron, for the information.

Yes, "$" was what I missed. I modify the example and use a range, and it works beautifully for V. 2003 as well. I like this tip and I see some users can really apply it.

You CANNOT use EVALUATE in a worksheet cell by itself (you never could).

What *stand-alone* function can I use in place of EVALUATE then?

Epinn

"Ron Rosenfeld" wrote in message ...
On Sat, 14 Oct 2006 19:57:04 -0400, "Epinn"
wrote:

Does EVALUATE( ) still exist in V. 2003? I couldn't find it from Excel Help. Seeing that DATEDIF can't be found via F1 but still alive and kicking, I need to hear about EVALUATE ( ) for sure although I think I see something like "undefined." If it is not available, what do we use now? I found it from the following writeup. By the way, does naming a formula goes thru the same steps as naming a range on a worksheet? InsertNameDefine?

************************************************* *********************

Created by David Hager
To add comma delimited values in a cell (such as 1,2,11,4 in cell A1) to
the right of the cell containing the string, highlight cell B1 (for this
case) and create the following defined name formula (called "csum"):

=EVALUATE(SUBSTITUTE(A1,",","+"))

Then, type =csum in B1 to obtain the result (18, in this case).

************************************************* **************

Thank you for your help.

Epinn



It is still present in Excel 2002.

BUT

EVALUATE is an old macro command from when Excel used to have Macro sheets.

Entering and using it in the manner outlined by Hager still works in Excel 2002
and I'd guess it'd work in Excel 2003. But I believe you need to use an
absolute reference in the defined name formula.

You CANNOT use EVALUATE in a worksheet cell by itself (you never could).


--ron