MatchCase in find function

[vbaNewby]

Hello,

What is the matchCase parameter in the find function?

Does it mean that it only finds EXACT matches. So say my cell is "hello"

If matchCase = true

then will it pick up:

"hello world"
"world hello"

or just

"hello"

Thanks in advance.

 

[Scott Huish]

From the help file:

MatchCase Optional Variant True to make the search case sensitive. The default value is False.

If MatchCase were set to TRUE, and you were searching for hello, it would not match HELLO because that is in upper case (it does not match case), nor it would it match Hello (not all lower case)

 

[vbaNewby]

From the help file:



If MatchCase were set to TRUE, and you were searching for hello, it would not match HELLO because that is in upper case (it does not match case), nor it would it match Hello (not all lower case)

Thanks HOTPEPPER, so how can I use the find function to find exact matches "hello" and NOT "hello world"

????

 

[Scott Huish]

Set LookAt to xlWhole

 

[vbaNewby]

From the help file:



If MatchCase were set to TRUE, and you were searching for hello, it would not match HELLO because that is in upper case (it does not match case), nor it would it match Hello (not all lower case)

Is it this???:


LookAt:=xlWhole</pre>

 

[Scott Huish]

Yes.

 

[vbaNewby]

Yes.