VBA has its own version. Look at InStr in VBA's help.



Sybmathics wrote:

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

--

Dave Peterson