title: Using .find looking between two values
body: <p>I am working on bank reconciliation worksheet and American Express takes out their credit card fees on a daily basis. On our worksheet we assume a 3.1% cost daily so if total AX revenue was $100 we would be expecting $96.9. The actual amount deposited will vary from that amount but almost never more than 1%. I'm trying to create a code that will look for a value between 96.9 * 1.01 &amp; 96.9 &amp; 99. Here is what I have so far. I'm getting an error with what I'm putting in the .find(what:>findstring3 &amp; 
  
  <p>Sub CreditCardRec()</p>
  
  <pre><code>For i = 1 To 200
  
  Windows("4110 Bank Rec 112100.xlsm").Activate
              findstring = Sheets("button").Cells(i, 30).Value
                  If Trim(findstring) &lt;&gt; "" Then
                      findstring2 = findstring * 1.01
                      findstring3 = findstring * 0.99
                      With Sheets("Amex").Range("N:N")
                          Set rng = .Find(what:&gt;findstring3 &amp; &lt;findstring2, _
                              LookIn:=xlValues, _
                              lookat:=xlWhole, _
                              searchorder:=xlByRows, _
                              searchdirection:=xlNext, _
                              MatchCase:=False)
                          If Not rng Is Nothing Then
                              Application.Goto rng, True
                              ActiveCell.Offset(0, 1).Select
                              ActiveCell.Value = findstring
                          End If
                      End With
                  End If
  
              Next i
  </code></pre>