title: Loop through cells/merged cells in column
body: <p>I am very new to Excel VBA and haven't quite familiarized myself with all the different functions. This is what I would like to have happen:</p>
  <p>I have a column containing value in combination of cells and <strong>merged cells</strong>. I have to perform an action in <strong>for</strong> <strong>loop</strong> for that column. I want the loop to move from 1 cell to next and not based on the row. e.g cell C1 is merged cell (C1-C3) so the loop should next go to C4 rather than C2.
  In the attached image, I want the loop to go like C1 -&gt; C4 -&gt; C5 -&gt; C7 -&gt; C11 and like that..</p>
  <p><img src="https://i.stack.imgur.com/JHsZS.png" alt="enter image description here" /></p>