View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Using Concatentate in Formula

EVAL also is packaged with Laurent Longre's MOREFUNC

http://longre.free.fr/english/index.html


Gord Dibben MS Excel MVP

On Fri, 23 Jun 2006 16:45:01 -0700, SteveC
wrote:

Dave,

turns out I had another addin that I forgot about called FastExcel. It
seems like FastExcel has integrated a number of freely available functions.
I haven't really used it much so I can't say much about it.

After grandly announcing the completion of a spreadsheet model, I emailed
the spreadsheet out to a few coworkers. However, the cells using EVAL did
not work because EVAL was pointing to a nonexistant install of FastExcel on
my coworker's c drives...

Your advice on adding the UDF to the workbook fixes that problem...

Really glad you provided that UDF... thanks...

Do you know where I can get other UDF codes? Seems like using add-ins
really is not a good solution when you are emailing files to others...


"Dave Peterson" wrote:

Maybe it's an undocumented feature <bg.

Or maybe it's in another addin???



SteveC wrote:

I have Walkenbach's Power Utility Pack installed, but there's no listing of
EVAL in that...

"Dave Peterson" wrote:

I use xl2003, too.

Can you find it in xl2003's help?

If you type
=eval(
and click on the Fx button (to the left of the formula bar), what do you get?



SteveC wrote:

thanks Dave... Maybe "EVAL" is native to Excel 2003? it's what I'm using...

--

Dave Peterson


--

Dave Peterson