>Thank you,
>I have change the code as
>Fc = oExcel.Worksheets("Sheet2").Columns("A").Find("100")
>After searching i have do this.
>IF FC = .NULL.
> .....
>ENDIF
>Fc return .null. but the if endif statement does not work.
>Why
A comparision of any variable to .NULL. returns .NULL., which is not .T. or .F., so the IF statement fails. Try this, instead:
IF ISNULL(FC)
...
ENDIF
- della