Sorry Chris for some reason when I posted it inserted FindFind.

Thanks for getting back

code:
$SourceObjectRow = $ObjExcel.Range("A1:C2500").Find($SourceObject,,,$xlWhole,,,,)

xlWhole is not a verable but a function within the .Find Command.

I think it should be:

code:
 $SourceObjectRow = $ObjExcel.Range("A1:C2500").Find($SourceObject,,,xlWhole=true,,,,)

Nope still don't work [Frown]

I think Shawn is an expert on this [Big Grin] .

Thanks

[ 20. May 2003, 13:09: Message edited by: Richard Farthing ]