Skip to main content

Range.HorizontalAlignment property

Table of contents
  1. Syntax
  2. Remarks
  3. Examples

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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>