Search a string to contains....

[ValerieT]

Hello

I am struggling with stupid problems, sorry to bother you with beginner questions

I've got checks on column headers (to insure essential information exists):


Set Found = Rows(1).Find(What:="FTE", After:=Cells(1, 5))



What syntax will give me a Found =OK, based on header "contains" FTE, and no "match exactly" like it does now?

[lecxe]

Hi Valerie

Please look at the help of the Find() method of the Range object to know what options are available to you.

In this case, maybe you want:



Set Found = Rows(1).Find( _
What:="FTE", _
After:=Cells(1, 5), _
LookIn:=xlValues, _
LookAt:=xlPart, _
MatchCase:=False)

[ValerieT]

Thanks a lot.

I always check the help before, but in that case, see below the help I've got. Should have I understood that it doesn't stops at Arg3, and that there always can be more optional arguments?




Excel Developer Reference



WorksheetFunction.Find Method



Finds specific information in a worksheet. Syntax
expression.Find(Arg1, Arg2, Arg3)
expression A variable that represents a WorksheetFunction object.
Parameters


Name

Required/Optional

Data Type

Description



Arg1

Required

String

The name of the worksheet.



Arg2

Required

String

The name of the range.



Arg3

Optional

Variant

The name of an argument to refine the search.




Return Value
Double
© 2010 Microsoft Corporation. All rights reserved. (http://www.vbaexpress.com/forum/HV10322970.htm)

[lecxe]

Hi Valerie

I'm glad it helped.

The help you posted is the help on the Find() method of the WorksheetFunction object.

You should check the help on the Find() method of the Range object. There you can find the options you need for this case.

[ValerieT]

I just press F1 and it comes automatically... Life is not fare to empiric self learning beginner :-)

Thanks you again and have a nice day

[lecxe]

You're welcome. Thanks for the feedback.