title: Excel VBA - increment column reference in range
body: <p>How do I increment the column reference in the code below? Just the column ref, the row values can stay the same.</p>
  
  <pre><code>Range("w3:w54").PasteSpecial
  </code></pre>
  
  <p>I'm hoping I can do something like this:</p>
  
  <pre><code>For i = 23 to 27
  'start at column w (which is number 23)
  
  Range(Columns(i)+"3":Columns(i)+"54").PasteSpecial  
  
  Next            
  </code></pre>
  
  <p>But that throws an error. </p>
  
  <p>Any suggestions?</p>