I didn't 'find' any noticeable difference but an accurate timer showed it
was perhaps marginally faster to search in formulas than values.

Regards,
Peter T

"Dave Peterson" wrote in message
...
But for me, I couldn't tell the difference between searching through
formulas or
values.

I still don't have a guess, though.

vbapro wrote:

I have tried to reproduce the problem in the original file, and now it
seems
to me that I had been confused by the following.

When you open Excel the LookIn option in the Find dialog box is set to
xlFormulas. In my code I used LookIn:=xlValues, and according to the
help,
the options of Range.Find method and in the Find dialog box correspond
to
each other and are saved every time they changed during one Excel
session.
So, after my code has been run xlValues was used in the Find dialog box.
Apparently, then search with xlValues is slower than with xlFormulas.
This
had confused me.

Thank you!

"Dave Peterson" wrote:

I bet the OP will disagree! <vbg

Peter T wrote:

Oh I wouldn't say that - you found there was nothing to find, sounds
like a
finding to me <g

Regards,
Peter T

"Dave Peterson" wrote in message
...
Findings = lack of findings!!!

Peter T wrote:

"Peter T" <peter_t@discussions wrote in message
<snip

Keep your fingers crossed that Dave might see what's slowing
down
your Find !

I see Dave had already posted his findings

Peter T

--

Dave Peterson

--

Dave Peterson


--

Dave Peterson