title: Concatenating Variables Into String to be Set to a Range in VBA
body: <p>I am having a problem with a particular line of code:</p>
  
  <pre><code>ActiveSheet.Range("A" &amp; rowCount &amp; ":" &amp; Mid(alphabet, totHdrLngth, 1) &amp; belowRowCount)
  </code></pre>
  
  <p>Where alphabet is a string containing uppercase letters A to Z.</p>
  
  <p>I keep getting the following error:</p>
  
  <pre><code>Run-time error '5':
  Invalid Procedure call or argument
  </code></pre>
  
  <p>I tried creating a String "inRange" and changing the code to this:</p>
  
  <pre><code>inRange = "A" &amp; rowCount &amp; ":" &amp; Mid(alphabet, totHdrLngth, 1) &amp; belowRowCount
  curRange = ActiveSheet.Range(inRange)
  </code></pre>
  
  <p>But that did not help (as I thought it wouldn't). Any suggestions?</p>