title: Create dynamic url using value from cell
body: <p>I am running a web query for an Excel sheet and have been able to pull data correctly however I want to reference a cell that can be changed in the worksheet.  </p>
  
  <p>Ex. I want to make the F reference a cell so I can easily change the request without changing the code. I've been trying to use a range function.</p>
  
  <pre><code>Sub URL_Get_Query()
  
  With ActiveSheet.QueryTables.Add(Connection:= _
      "URL;http://finance.yahoo.com/q/is?s=F+Income+Statement&amp;annual", _
      Destination:=Range("a1"))
  
      .BackgroundQuery = True
      .TablesOnlyFromHTML = True
      .Refresh BackgroundQuery:=False
      .SaveData = True
  End With
  End Sub
  </code></pre>