HorizontalAlignment Property Example
This example left aligns the range A1:A5 on Sheet1.
Worksheets("Sheet1").Range("A1:A5").HorizontalAlignment = xlLeft