Style.VerticalAlignment (Excel)

Returns or sets an XlVAlign value that represents the vertical alignment of the specified object.

xlVAlignBottom - Bottom, xlVAlignCenter - Center, xlVAlignDistributed - Distributed, xlVAlignJustify - Justify, xlVAlignTop - Top.

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.

ActiveCell.Style.VerticalAlignment = xlVAlignBottom
Style.VerticalAlignment procedure builder