Re: VBA Find function sometimes not working
Quote from StephenR;608344
Specifying all the parameters might solve the problem. If you record a macro of using Find it will generate all the necessary syntax which you can then paste into your code. If that doesn't do it, a sample workbook would help.
Thanks for your reply. I tried adding some of the parameters that I though could make a difference, but not all. I'll look into this and will try some more. A sample workbook unfortunately won't help. I have about 10 Excel files with heavy VBA code which are run every day and those have hundreds of Find functions - none of those are causing any problems. Even if I take the one file that currently causes sometimes an issue and I try it on my PC, I can't replicate the issue. The only difference is that on the one PC where this phenomena appears, a few other VBA programs are executed beforehand. Hence my thought that Excel might keep some Find parameters in the memory or that Excel can't handle that many Find calls...
I'll try to specify more parameters and see if it makes any difference.
I welcome any other hints, ideas or background knowledge on how Excel managaes Find methods, results and parameters