CellFormat.VerticalAlignment (Excel)

Returns or sets a value that represents the vertical alignment of the specified object. Possible return values are xlVAlignBottom - Bottom, xlVAlignCenter - Center, xlVAlignDistributed - Distributed, xlVAlignJustify - Justify, xlVAlignTop - Top.

TThe value of this property can be set to one of the XlVAlign constants.

Application.FindFormat.VerticalAlignment = xlVAlignBottom