[Excel] Find & FindNext Method Problem

[zkidkid]

Hi All,

I am working with excel, and using this find/findnext method.
Here is my code :

Excel.Range rgn;
Excel.Range usedRange = workSheet.UsedRange;
rgn = usedRange.Find("mystring", missing, missing, missing, missing, XlSearchDirection.xlNext, missing, missing, missing);

And it seem okie. After that i used findNext method :

rgn = usedRange.FindNext(rgn);

but rgn is the same with last one. although there have many "mystring" in workSheet.

I also had tried with this code :

rgn = UsedRange.Find("myString", workSheet.Cells[startRow,startColumn], missing, missing, missing, XlSearchDirection.xlNext, missing, missing, missing);

Thanks.