The test run cannot continue due to an unrecoverable error

[Ankesh]

if the value that you are looking for is not found, it will throw the error.

You can try the below code

Code:

intStartRange="A1"
intEndRange="A50"
intFoundRow=ExcelApp.Range(intStartRange,intEndRange).Find(<ValueBeingSearched>).Row

Please note this will always return the row number where the value was first found. To get the next occurance row, you need to set the range again.

Let me know if you need more help.

Regards,
Ankesh