title: find if `find` method returns `nothing` in excel vba
body: <p>I'm trying to find an id in a list and get it's address, but also deal with a situation if nothing is found.</p>
  
  <p>Here's what I have:</p>
  
  <pre><code>Function find_in_two_ranges_two_sheets(ws1 As String, col1 As Integer) As Range
  
      Dim rows1 As Integer
      rows1 = Get_Rows_Generic(ws1, 1)
      Dim range1 As Range ' range of first search
      With Worksheets(ws1)
          Set range1 = .Range(.Cells(1, col1), .Cells(rows1, col1))
      End With
  
      Dim found1 As Range
      Set found1 = range1.Find("test id", LookIn:=xlValues)  
  
      If found1 = Nothing Then
          MsgBox "nothing"
      Else
          MsgBox found1.AddressLocal
      End If
  
  
      Set find_in_two_ranges_two_sheets = range1
  End Function
  
  
  Sub test_stuff()
      Dim x As Range
      Set x = find_in_two_ranges_two_sheets("usersFullOutput.csv", 1)
      MsgBox x.Address
  End Sub
  </code></pre>
  
  <p>When I run <code>test_stuff()</code> I get an error in the function in the line <code>If found1 = Nothing Then</code> with the word <code>Nothing</code> highlighted. "Compile error; Invalid Use of Object".  Not sure what to do.</p>