Biff,

Wow! You read my mind. I was happy with my test on a range but I felt that it wasn't dynamic enough. With your formula, I don't have to hard code the range when I define the formula. Great!

However, I am not familiar with R1C1 references; my only encounter with it is via ToolsOptionsGeneral. I know "FALSE" in the formula indicates that R1C1 style is used. Can you or someone point me to some reference material on R1C1 please?

I tested RC[+5] for the fifth column to the right. I know INDIRECT is not confined to the local sheet with A1-style. How about R1C1-style? Can we refer to a different sheet? What are other codes than RC[ ]?

Thanks.

Epinn

"Biff" wrote in message ...
But I believe you need to use an
absolute reference in the defined name formula.

You can use R1C1 references:

=EVALUATE(SUBSTITUTE(INDIRECT("RC[-1]",FALSE),",","+"))

Refers to the column to the immediate left of the column where the formula
is entered. For example, if the formula (=csum) was entered in B1 the
reference would be to A1.

Biff

"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