Returns or sets a Variant value that represents the horizontal alignment for the specified object. Read/write.
expression A variable that represents a Range object.
The value of this property can be set to one of the XlHAlign constants.
Some of these constants may not be available to you, depending on the language support (U.S. English, for example) that you've selected or installed.
The following code sets the horizontal alignment of cell A1 to center.
Range("A1").HorizontalAlignment = xlCenter