View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default Macro - Find Function not working

Hi

If it is the worksheetfunction find you want to use, you have to use:

WorksheetFunction.Find(...)

If this does not help, post your code for further help.

Regards,
Per


"Greg T" skrev i meddelelsen
...
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?