Style.VerticalAlignment (Excel)
Returns or sets an XlVAlign value that represents the vertical alignment of the specified object. Possible return values are 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