Ken,
I'll start to answer a few basic questions. If you're in
the Excel VBE, hit the F2 button which exposes the Object
Browser window. On the left hand pane enter "r" to get
down the list and locate "range". Over on the right hand
pane you'll see a list of properties and methods of the
range object. The green bricks are methods. The hand with
the page are properties.

Even though I've been programming in Excel since 1997, I
still rely on the Object Browser a lot.
Geof.
-----Original Message-----
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



.