Dave Peterson says FIND does work in a User Defined Function (UDF) used in a
worksheet in xl2002 and later. Just for information.

--
Regards,
Tom Ogilvy

"Alan Beban" wrote in message
...
Eros Pedrini wrote:
I have a problem using the find method of range object. It works fine if
I
use into a Sub procedure; but fails (i.e. return nothing all time) if I
use
it into a Function.

The Function works if it is called from a Sub Procedure; it doesn't if
it is called from a Worksheet. That's just the way it is in Excel.

Alan Beban