title: If value is not found while searching excel
body: <p>I have the below code:</p>
  
  <pre><code>        Dim xlApp As Excel.Application
          Dim xlBook As Excel.Workbook
          Dim xlSheet1 As Excel.Worksheet
          Dim rng As Excel.Range
          Dim codeabc As String
          Dim i As Integer
          If StoreNumber.Text = String.Empty Then
              MsgBox("Please fill out 'Store Number'")
              Exit Sub
          End If
          xlApp = CreateObject("Excel.Application")
          xlBook = xlApp.Workbooks.Open("C:\Users\jefhill\Desktop\MyUPS.csv")
          xlSheet1 = xlBook.Worksheets(1)
          rng = xlSheet1.Range("a1:a3000")
          codeabc = (StoreNumber.Text)
          For i = 1 To rng.Count
              If rng.Cells(i).Value = codeabc Then
                  Address.Text = (rng.Cells(i).offset(0, 1).value()) &amp; vbCrLf &amp; (rng.Cells(i).offset(0, 2).value()) &amp; " " &amp; (rng.Cells(i).offset(0, 3).value()) &amp; " " &amp; (rng.Cells(i).offset(0, 4).value())
                  Phone.Text = (rng.Cells(i).offset(0, 5).value())
              End If
          Next i
          xlBook.Close()
  </code></pre>
  
  <p>The above works fine. But I am trying to add a way where if the value you are searching is NOT found. I have tried adding a 'else' to the 'if' statement, but that just had it give the error every time. </p>