Hi. When I had tyo program MSGraph, I use a trick I got somewhere (I don't remember where...). Try to record a macro by doing by hand what you want to do by code and go see the code after stopping the recording.

To know the value of constant, simply write a macro that write the value xlCenter in a cell. You can modify the macro to display any constant.

>I'm using..
>oSheet.Range("A1:A1").HorizontalAlignment = xlCenter

>But I dont know the numeric equivalent of xlCenter....