title: Looping through Merged cells in VBA
body: <p>Is it possible to loop through merged cells in <a href="/questions/tagged/vba" class="post-tag" title="show questions tagged &#39;vba&#39;" rel="tag">vba</a>.</p>
  
  <ul>
  <li>I have 6 merged cells in the range <code>B4:B40</code></li>
  <li>I need the values in these 6 cells 6 iterations only.</li>
  </ul>