When I am not sure of a value of an Excel constant, I go to Excel Macro (Visual Basic Window) and in the Immediate Window you can type:
?Constantname
and it return the value in the window.
See screenshot.
>ok la ~~~ thank for your help ........
>but oRng.HorizontalAlignment = 1 not equal to algin left?
>
>
>oRng.HorizontalAlignment = 4 < equal to algin right?
>oRng.VerticalAlignment = 4
>
>
>oRng.HorizontalAlignment = 3 < equal to algin center?
> oRng.VerticalAlignment = 3
>
>
>
Christian Isberner
Software Consultant