Center Align
give this a try
With Worksheets(5).Range("b25..b27")
..HorizontalAlignment = xlCenter
End With
--
Gary
"John 3:16" wrote in message
...
Thanks for the reply Bill.
I tried this:
xlBook.Worksheets(5).Range("b25..b27").cells.Horiz ontalAlignment =
xlCenter
This, and other variations I've tried... does not work.
what should the correct syntax be?
thanks in advance,
bob.
"Bill" wrote in message
ink.net...
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
|