title: constant expression required - vba
body: <p>I'm trying to create an URL that changes based on what I put in cell "A1", however, I keep getting a compile error "Constant expression required". </p>
  
  <p>The error is on the second line at "banana".</p>
  
  <pre><code> banana = Range("A1")
  
   Const URL As String = "http://openinsider.com/screener?s=" &amp; banana &amp; "&amp;o=&amp;pl=&amp;ph=&amp;ll=&amp;lh=&amp;fd=730&amp;fdr=&amp;td=0&amp;tdr=&amp;fdlyl=&amp;fdlyh=&amp;daysago=&amp;xp=1&amp;xs=1&amp;vl=&amp;vh=&amp;ocl=&amp;och=&amp;sic1=-1&amp;sicl=100&amp;sich=9999&amp;grp=0&amp;nfl=&amp;nfh=&amp;nil=&amp;nih=&amp;nol=&amp;noh=&amp;v2l=&amp;v2h=&amp;oc2l=&amp;oc2h=&amp;sortcol=0&amp;cnt=100&amp;page=1"
   Const READYSTATE_COMPLETE As Integer = 4
  </code></pre>