Dave,

Actually, along the same lines of this post I was looking at Stephen
Bullen's site and he has a charting example from 1998 that uses EVALUATE
combined with defined names to chart a function. It does pretty much what
you've described below. I can't seem to find anything in the Excel 2003 Help
that describes this function either. Would you know why there doesn't seem
to be any documentation on this (or maybe I'm just missing it).

Thanks.

----
John Mansfield
http://www.pdbook.com

"Dave Peterson" wrote:

Maybe you have an addin that contains a homegrown =Evaluate() function.

They're pretty common around here.

Usually, developers write them to evaluate a string.

In A1:A3 (for instance)
a1 = 3
a2 = +
a3 = 5

=evaluate(a1&a2&a3)

could return 5--but it really depends on what the author of the function did.

If you have an addin that you load (maybe downloaded from the web), maybe it's
one of the functions in that. If you think you know that addin's name, post it
and I'm sure someone can be more specific.

=======
And there is an Evaluate that can be used in VBA--but I didn't guess you meant
that.

"Frank H." wrote:

I have looked on the internet but can't seem to find much
information on Excel's EVALUATE Function. I see it being
used but don't seem to have it in my function list with
Excel 2003. Can someone provide an explanation of the
EVALUATE function i.e. what it does, a little history,
etc. Thanks for your help.

--

Dave Peterson