Rod,

I have been searching and searching for a list of the numerical values of those contstants to no avail, any idea where that list is available ?

Gerry.

>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