Excel’s ‘Find function’ does not work on MacBook.

Question

Device used: MacBook Pro 13, M2, 2022 model

When using the find function in Excel

Runtime error '1004':

Application-defined or object-defined errors

An error occurs.

To solve this

1. Delete and reinstall Excel,
2. In the Security window, set 'Include all macros (not recommended as it may run dangerous code)' and 'Allow safe access to the VBA project object model'.
3. Check for Excel updates
4. Reboot Excel

I tried but it still doesn't solve the problem. How can I solve this?

The current version name of Excel is 16.77.1 and the build number is 23091703. Solver problem also occurs in other files. At first, I thought I had used the solver function incorrectly, so I tried again, but the same problem occurred.

Answer 1

Hi,

I suggest referring to these articles-

https://community.spiceworks.com/how_to/195135-how-to-fix-run-time-error-1004-in-excel

https://excelchamps.com/vba/runtime-error-1004/