title: How do I avoid merging cells vertically in excel?
body: <p>I'm tired of merged cells. They just don't work.</p>
  
  <p>So I found a way to avoid merging cells horizontally, when I just need my text to be centered across multiple columns. That's: <code>Range("A1:C1").HorizontalAlignment = xlCenterAcrossSelection</code>. </p>
  
  <p>It works like a charm. It's perfect. It's just what I needed.</p>
  
  <p>I oh-so-naively thought you could do the same vertically, for centering text over multiple rows. Something like: <code>Range("A1:A3").VerticalAlignment = xlCenterAcrossSelection</code>. </p>
  
  <p>But alas, that doesn't work. </p>
  
  <p>Am I missing something here, or did Excel developers really think that, while centering across columns is a common deal, centering over rows is so much of a silly idea nobody would ever do that so why even bother?</p>