I'm trying to use the .find function on a range in a vba user defined function.
I've found though the .find does not work in a user defined function for vba on mac osx, even when the same code works on a windows platform.

It's strange as .find appears to work with sub routines, but with UDFs it causes the function to exit with no error messages

Has anyone else noticed this and found a solution.