VBA Excel VerticalAlignment = xlCenter not working <p>The below code selects the sheet but fails to align the cells to center.</p> <pre><code> wb.Sheets(1).Columns("A:L").Select With Selection .VerticalAlignment = xlCenter End With </code></pre> <p>Thanks!</p> <pre><code>wb.Sheets(1).Activate wb.Sheets(1).Columns("A:L").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("A:L").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>