I use this statement to create a range of cells from the 'InColumn' column

Set rFound = Columns(InColumn).Find(findIt)

Things were working fine, then all of a sudden, it stopped finding anything
regardless of what I set 'findIt' equal to.

It was driving me crazy and I finally tried to record a whole macro and
start over. Problem was I couldn't record a 'Find' macro.

But in the process of trying, I looked at the options for the find and saw
that the "Match entire cell contents" was selected. I turned that off and,
since findIt will only be found as a substring, when went back and ran the
replace macro, it magically worked again. Jeez, this lesson took hours.

So this is how I am trying to think of this VBA stuff, and please help me
out here,

"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.

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?

Thanks for any help and insights.

Ken Loomis