View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Does EVALUATE( ) still exist in V. 2003?

On Sat, 14 Oct 2006 23:24:52 -0400, "Epinn"
wrote:

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


There is no stand-alone function that you can use, unless you write one of your
own in VBA.


--ron