Gerry,
Here's what code was written by the Excel Macro recorder when I aligned a cell. The real way to master Automation is to use the macro recorder in the application you are automation in combination with the object browser of VB/VBA.

The constants shown have the following values
xlBottom = -4107
xlRight = -4152

Range("A1").Select
With Selection
.HorizontalAlignment = xlRight
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.ShrinkToFit = False
.MergeCells = False
End With


Hope this helps...
Rod