Look in the VBA help index for FIND or record a macro while doing your find
to see how.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sybmathics" wrote in message
...
Hi all,


I am wondering why some orksheetfunctions can be addressed and others
can't.

If you look in the autolist of application.worksheetfunctions there is no
suggestion for Find.
But, when you address it in a module as
mystring=application.worksheetfunction.find(all the proper arguments) it
will run as expected.
However, with the worksheetfunctions like value or date, when run in a udf
you will always end up with #value!.

What's the logic?


Any help is greatly appreciated.

Greets


Sybolt