title: With Sheets("").Range("B:B"); Variable range when searching
body: <p>Here´s the thing, I have a code that uses a fixed range in a fixed sheet to search for a value. I need now to make the sheet variable. I´ve tried couple of things with no luck so far.
  The name of the sheet where I need to search is determined by a cell in another sheet. Replacing the 3rd line with something like: "With Sheets("Sheets("asd").range("A1")").Range("B:B") does not work.</p>
  
  <p>My code:</p>
  
  <pre><code>    FindString = W
      If Trim(FindString) &lt;&gt; "" Then
          With Sheets(**"CARS"**).Range("B:B")
                     Set Rng = Cells.Find(What:=FindString, _
                              After:=.Cells(.Cells.Count), _
                              LookIn:=xlValues, _
                              LookAt:=xlWhole, _
                              SearchOrder:=xlByRows, _
                              SearchDirection:=xlNext, _
                              MatchCase:=False)
          If Not Rng Is Nothing Then
                  Application.Goto Rng, True
              Else
                  MsgBox "Nothing found"
              End If
          End With
      End If
  </code></pre>
  
  <p>Let me know if more info is required.
  Thanks!</p>