Exampe:

cells(1,1) .HorizontalAlignment = xlRight
cells(1,1).VerticalAlignment = xlRight

Can use xlTop, xlBottom, xlRight, xlLeft



"John 3:16" wrote in message
...
Hello,

I know that using
xlBook.Worksheets(5).Range("C25..B27").Font.Bold = True
will set the cell attribute for the given range to Bold.

How do I set the alignment to "Center, left or right"

thanks in advance,
bob mcclellan