I couldn't understand your explanation on Evaluate.

The thread on Oct. 14 that I mentioned in my previous post explains EVALUATE ( ) in great detail. A real life example was given. It would be worth reading. Did you have a chance to take a look?

Epinn

"Rasoul Khoshravan" wrote in message ...
Thanks for your reply but I couldn't understand your explanation on
Evaluate.

"Kevin Vaughn" wrote in message
...
Since no one else has replied yet, I'll take a shot. I created a named
range
called test1 as:
=EVALUATE(Sheet3!D5+Sheet3!E5)
Both d5 and e5 had numbers, and when I put =test1 into a cell, it gave me
the sum of those numbers.

I have a feeling, but am not positive, that evaluate was part of the prior
macro language that Excel used; I believe it was called XLM.

BTW, as the cells reference are relative, if I use the =test1 formula
elsewhere, it should give me the answer using the cells relative to where
my
cursor was prior to creating the named range (I believe I was in D6 when I
created the range name.) Let me test this to make sure by putting the
formula in a different cell and observing the results:
So, it turns out that I was in E6 when I created the named range and yes,
it
does add the cell above and the cell above and to the left wherever you
enter
the formula =test1

If it is indeed from XLM, then there is a caveat to watch out for (and I
never remember the exact details. Something like don't copy the name or
the
spreadsheet to another workbook or, at least in Excel 2000, it could cause
a
crash.) I never have and never will experiment with this to see if it
does
happen as I never deliberately try to crash my system.
--
Kevin Vaughn


"Rasoul Khoshravan" wrote:

Is this a command name in Excel?
What is its function?