Hi Everyone

OK check this line out and tell me what I am doing wrong, I want to search a range for a value, but the value must be excact.

E.G Search for Rich, and in the data I have Richard and Rich.

Well I want it to just pick up on the Rich, not the Richard.

code:
 
$SourceObjectRow = $ObjExcel.Range("A1:C2500").FindFindFind($SourceObject,,,xlWhole,,,,)
I get an expected expression! error.

It works fine if I don't want excact matches, by using:
code:
 
$SourceObjectRow = $ObjExcel.Range("A1:C2500").FindFindFind($SourceObject)
I quote from the microsoft.

quote:

expression.Find(What, After, LookIn, LookAt, SearchOrder, SearchDirection, MatchCase,úMatchByte)

LookAt Optional Variant. Can be one of the following XlLookAt constants: xlWhole or xlPart.
Thanks

Rich