Thanks for that confirmation.

If the anyway to store the settings for the Find method so I can set them
back to what they were after I am with the find?

Ken Loomis

"Dick Kusleika" wrote in message
...
Ken

As you discovered, the Find method will use the last used setting for any
arguments that you omit. The last used setting is set in both VBA and the
user-interface.


"Find" is a method(?) that belongs to a range object(?)

the Find method has parameters(?)/setting(?)/options(?)

If those parameters (or whatever they are called) are already set, the
method uses whatever those are set to

So, here are my questions:

1) How do I access those settings values? Seems polite to store these
before
simply changing them.

I believe the only way to change those is the through the arguments of the
Find method and through the user interface. That seems to imply that you
can't get/change those settings anywhere else.


2) How do I change them? So I can clean things up after I am done, like I
was taught in Kindergarten ;-)

3) Is there a way to use the Find method and just specify my desired
settings, without changing them?

No. The best course, in my opinion, is to explicitly set every argument
when using the Find method every time. Since these settings are easily
viewed in the UI, don't worry that the user will have to change them.
It's
most likely that the user won't know what they were before. That may not
pass the Kindergarten test, but I think it's the best option.

See also http://www.dicks-blog.com/excel/2004...nd_method.html

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com