As Roger suggested in the thread, prepare the worksheet i.e. define the formulae (InsertNameDefine), key in the column headings, enter the formulae to the cells etc. etc. If you like you can even use ToolsFormula AuditingEvaluate Formula to see the steps of the formula unfold. I think doing it is more effective than reading and thinking. Just a thought.

By the way, when you first posted, did you have EVALUATE ( ) or Evaluate Formula tool in mind? I am curious.

Epinn

"Rasoul Khoshravan" wrote in message ...
thanks. I read it but need more time to think and understand.
If I understand correctly, it stores a series of functions under name and
uses EVALUATE funtion to recall it. Is this correct?

"Epinn" wrote in message
...
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?