title: Using an Or function within Range.Find VBA
body: <p>Is it possible to put and OR function within a range.find? I have this function but I'd like it to look for either of 2 values</p>
  
  <pre><code>With Worksheets("Term").Range("A:A")
  
      Set rng = .Find(What:=Worksheets("Term and Discipline").Range("K7"), _
          After:=.Cells(.Cells.Count), _
          LookIn:=xlValues, _
          LookAt:=xlPart, _
          SearchOrder:=xlByRows, _
          SearchDirection:=xlNext, _
          MatchCase:=False)
          Application.Goto rng, True
  
  End With
  </code></pre>
  
  <p>In the line where you provide what it's looking for I've tried to put in an OR statement but Excel gets mad at me when I try to run it</p>