title: Excel Find operation in C# will skip the first row
body: <p>Below is a working code. I figured out that in the find criteria that by changing the starting point of the search criteria as: wsSheet.Cells[65000, columnNumber] it will solve the issue. This is not a real solution though.</p>
  
  <p>Is there another way of forcing the Find operation to start at the first row of the excel sheet?</p>
  
  <pre><code>public static string FindFirstStringInColumn(Excel.Workbook wbBook, string strSheet, string strSearchMe, string strColumnLetter)
  
      {
          Excel.Worksheet wsSheet = null;
          wsSheet = (Excel.Worksheet)wbBook.Worksheets[strSheet];
          Excel.Range currentFind = null;
  
  
          Excel.Range range = (Excel.Range)wsSheet.Columns[strColumnLetter, Type.Missing];
          int columnNumber = ExcelCOM.GetColumnNumber(strColumnLetter);
          //~~&gt; Search for strSearchMe
          currentFind = range.Find(strSearchMe,
                          wsSheet.Cells[65000, columnNumber],
                          Excel.XlFindLookIn.xlValues,
                          Excel.XlLookAt.xlPart,
                          Excel.XlSearchOrder.xlByRows,
                          Excel.XlSearchDirection.xlNext,
                          false,
                          false,
                          false);
  
          if (currentFind != null)
          {
              string sAddress = currentFind.get_Address(false, false, Excel.XlReferenceStyle.xlA1, false, false);
              //~~&gt; Display the found Address
              return (sAddress).ToString();
          }
          else
          {
              return ("Nothing found");
          }
  
      }
  </code></pre>