title: VBA: Filter by a String Variable
body: <p>Everything works in this code except for the Autofilter by the variable Sector1.</p>
  
  <p>The idea is that the value in Sector1 (Dropdowns sheet cell B63) can vary. In the Review tab I want to search in column D of a specific section (between RngStart and RngStop) for the string value in Sector1. When it finds it, I want to copy the information in column G to the Mkting sheet starting at A16. I know this works because if instead of sector1 I put a valid Sector (e.g., "Health") in the code below, it works.However, with this code, it just copies everything in column G, without filtering for Sector1.</p>
  
  <pre><code>Sub test()
  
  Dim RngDest As Range
  Dim RngStart As Range, RngStop As Range
  Dim Sector1 As String
  
      Sector1 = Sheets("Dropdowns").Range("B63").Value
      With Sheets("Mkting")
          Set RngDest = .Range("A16")
      End With
  
      Set RngStart = Sheets("Review").Columns("A").Find("Impact Statements", , xlValues, xlPart)
      Set RngStop = Sheets("Review").Columns("A").Find("Quotes", , xlValues, xlPart)
  
      With Sheets("Review").Range("D" &amp; RngStart.row &amp; ":" &amp; "D" &amp; RngStop.row)
          .AutoFilter 1, Criteria1:=Sector1
          .Offset(1, 3).Copy RngDest
          .AutoFilter
      End With
  End Sub
  </code></pre>