title: VBA Excel VerticalAlignment = xlCenter not working
body: <p>The below code selects the sheet but fails to align the cells to center:</p>
  <pre><code>wb.Sheets(1).Columns(&quot;A:L&quot;).Select
  With Selection
      .VerticalAlignment = xlCenter
  End With
  
  wb.Sheets(1).Activate
  wb.Sheets(1).Columns(&quot;A:L&quot;).Select
  With Selection
    .VerticalAlignment = xlCenter
  End With 
  </code></pre>
  <p>Selects the entire sheet but it's not changing the vertical alignment to center.</p>
  <pre><code>wb.Sheets(1).Columns(&quot;A:L&quot;).VerticalAlignment = xlCenter
  </code></pre>
  <p>Does nothing.</p>
  <p>I don't want HorizontalAlignment :)</p>
  <p>I found out the column has VerticalAlignment set to xlCenter but the Cells underneath the column do not have VerticalAlignment set to xlCenter.</p>