Excel VBA: Cell Alignment

In Excel VBA macro we can control the alignment of cell, both horizontally and vertically. To change alignment, we can use the following properties of the Range object:

• HorizontalAlignment. Set to xlLeft, xlCenter, xlRight, xlDistributed, or xlJustify.
• VerticalAlignment. Set to xlTop, xlCenter, xlBottom, xlDistributed, or xlJustify.

Following example sets horizontal alignment to justify:

Worksheets("Sheet1").Range("A1:D5").HorizontalAlignment = xlJustify


Related Post:

• Number Formatting In Excel VBA Macro
• Changing Row And Column Size
• Font Formatting

---
If you like posts in this blog, you can to support me :)