If you're looking to find something in a string, then use VBA's built-in Instr()
function.

No need to use application.find() or worksheetfunction.find().



Greg T wrote:

When I used the FIND function in a macro I get an "Compile Error" function
not defined". It works fine when I use it in a cell in a worksheet. Is
there a seperate Reference that needs to be added?

--

Dave Peterson