| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Center Align
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Center Align
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Center Align
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Center Align
Thanks for the reply Gary.
This did not work either. The error message I receive from the DTS Package is: Error Source: Microsoft Data Transformation Services(DTS) Package Error Description: Error Code: 0 Error Source: Microsoft Excel Error Description: Unable to set the HorizontalAlignment property of the Range Class Error on line 53 Not sure why this will not take this syntax. I used it exactly as per your advice. thanks in advance, bob. "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Center Align
If anyone is interested...
this was the solution... ..HorizontalAlignment = -4108 ' Center bob. "John 3:16" wrote in message ... Thanks for the reply Gary. This did not work either. The error message I receive from the DTS Package is: Error Source: Microsoft Data Transformation Services(DTS) Package Error Description: Error Code: 0 Error Source: Microsoft Excel Error Description: Unable to set the HorizontalAlignment property of the Range Class Error on line 53 Not sure why this will not take this syntax. I used it exactly as per your advice. thanks in advance, bob. "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge and Center and Center Accross Selection | New Users to Excel | |||
| How do I center numbers in a cell, but align by decimal? | Excel Discussion (Misc queries) | |||
| How do I center align a title at top of sheet. | Excel Worksheet Functions | |||
| What is short-Cut forleft align and Right align? | Excel Discussion (Misc queries) | |||
| align text in the center of a range of cells | Excel Programming | |||
Linear Mode
