title: How to loop Ranges in VBA?
body: <p>I am a newbee in VBA, I have a problem that how to how to loop ranges in VBA
  for example:
  <code>Range("A1:D1").select</code>
  to 
  <code>Range("A100:D100").select</code></p>
  
  <p>or</p>
  
  <p><code>Range("A1:D1").select</code> to <code>Range("D1:G1").select</code>?</p>