.Range("&lnrangel").HorizontalAlignment = -4152 && Right Alignment
.Range("&lnrangel").HorizontalAlignment = -4131 && Left Alignment

hope it helps

Craig


> Hello Experts:
> I'm working with Excell automation and working with the cells format, i can format the font,fontsize, and type but i have'nt been able to set the cells alignment. Can anyone help. Also i will like some information about Automation error handling.
> The code i'm using to format the cells is something like this:
>
> .Range("&lnrangel").font.Name ="Times New Roman"
> .Range("&lnrangel").font.size="8"
> .Range("&lnrangel").font.bold=.T.
>
> Thank you
> Victor Del Valle
> Arecibo, P.R.