title: VBA Loop every two columns
body: <p>I have a fairly straight forward line of code which loops through the rows on a dataset. However I have realised that I am repeating this code within the loop 10 times because I need to do the same thing every other column.</p>
  
  <p>How can I loop through columns, so that this code works from Y to AA to AC columns etc rather than manually reapeating this for each column within the loop?</p>
  
  <pre><code>For i = 1 To Count
      ActiveSheet.Range("Y" &amp; i + 1).Select
      Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
      :=False, Transpose:=False
  Next i
  </code></pre>