HotXLS Docs

VerticalAlignment property

Returns or sets the vertical alignment of the specified range. Read/write XlVAlign.

Syntax

property VerticalAlignment: XlVAlign;

Description

VerticalAlignment can be one of these XlVAlign constants.
xlVAlignBottom
xlVAlignCenter
xlVAlignDistributed
xlVAlignJustify
xlVAlignTop

Example

This example centers the contents of the row two vertically.

Workbook.Worksheets[1].Range['A2', 'A2'].EntireRow.VerticalAlignment := xlVAlignCenter;