title: excel vba - loop down column with 4 cell range
body: <p>Basically I'm trying to write a loop -
  that on first iteration will have</p>
  
  <pre><code>srcT = Worksheets("I").Range("B1").Value
  srcC = Worksheets("I").Range("B2").Value
  trgT = Worksheets("I").Range("B3").Value
  trgC = Worksheets("I").Range("B4").Value
  </code></pre>
  
  <p>then 2nd iteration</p>
  
  <pre><code>srcT = Worksheets("I").Range("B5").Value
  srcC = Worksheets("I").Range("B6").Value
  trgT = Worksheets("I").Range("B7").Value
  trgC = Worksheets("I").Range("B8").Value
  </code></pre>
  
  <p>then 3rd iteration</p>
  
  <pre><code>srcT = Worksheets("I").Range("B9").Value
  srcC = Worksheets("I").Range("B10").Value
  trgT = Worksheets("I").Range("B11").Value
  trgC = Worksheets("I").Range("B12").Value
  </code></pre>
  
  <p>and continue with this pattern until a blank cell is encountered in column B.</p>