Gerry,
On MS site (and probably here ?) there is a file called wc0993.exe containing all office constants.
*!* If you cannot download wc0993.exe from microsoft site
*!* xlConstants can be found by :(or other office constants)
*!* -Open Excel
*!* -Select tools\macro\VB editor
*!* -Press F2 to bring up "Object browser"
*!* -Find needed xlConstant type ie:xlChartType
*!* -On right window click needed Constant ie: xl3DArea
*!* -Below the window constant value is displayed
Cetin
>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