title: How to add serial number in "different size merged cells" which are positioned "alternatively" in excel using VBA?
body: <p><a href="https://i.stack.imgur.com/oKtzq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oKtzq.png" alt="
  " /></a></p>
  <p>As shown in image, I am trying to fill numbers in <em>increasing order</em> in <strong>alternate merged cells,</strong> which are <em>different in size</em>. So, I <strong>can't use autofill function of excel</strong>. But I want a macro so I can do it every time just hitting button once.<bR>
  <strong>Note</strong> that I want numbers till the used range only.</p>
  <p>I tried a lot to do it my self, but I am stuck now...Plz help the beginner, it's my third day in VBA.</p>