title: VBA loop through range, by columns first
body: <p>Is their any way to loop through a range (ideally a for each cell in X) that can loop columns first? e.g. A1, A2, A3, A4 rather than A1, B1, C1, D1</p>
  
  <p>I tried transposing the range like, but alas this does not work</p>
  
  <pre><code>For Each cell In application.transpose(.Range("C3:G100"))
  </code></pre>
  
  <p>I have a feeling I am going to have to use something like</p>
  
  <pre><code>for c = 0 to .Range("C3:G100").columns.count
      for r =0 to .range("C3:G100").rows.count
  </code></pre>