| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
align data in a cell from VB
Please, advise how to align data in a cell to right (or
left) by using VB. Thanks, Alex |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
align data in a cell from VB
ActiveCell.HorizontalAlignment = xlHAlignLeft 'xlHAlignRight,
xlHAlignCenter -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Alex" wrote in message ... Please, advise how to align data in a cell to right (or left) by using VB. Thanks, Alex |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
align data in a cell from VB
Thanks a lot.
Alex -----Original Message----- ActiveCell.HorizontalAlignment = xlHAlignLeft 'xlHAlignRight, xlHAlignCenter -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Alex" wrote in message ... Please, advise how to align data in a cell to right (or left) by using VB. Thanks, Alex . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Align & compare data | Excel Discussion (Misc queries) | |||
| Align Data | Excel Worksheet Functions | |||
| how do i align rows of data | Excel Discussion (Misc queries) | |||
| Left align '$' and right align numbers? | Excel Discussion (Misc queries) | |||
| What is short-Cut forleft align and Right align? | Excel Discussion (Misc queries) | |||
![Alex[_13_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
