string colToCheck = "C40:C90" string SearchNo = "ABC-201"; Excel.Range resultRange; colRange = XLWorkSheet1.Range[colToCheck];//get the range object where you want to search from resultRange = colRange.Find( What: SearchNo, LookIn: Excel.XlFindLookIn.xlValues, LookAt: Excel.XlLookAt.xlPart, SearchOrder: Excel.XlSearchOrder.xlByRows, SearchDirection: Excel.XlSearchDirection.xlNext );
int findrow = resultRange.Row;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)