| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Align to the left or to the right (or center)
Excuse my poor English. Please I want to *align numeric values to the left side*, or to the right side, or center it in the cell in Excel. Using Visual Basic. Maybe using *Format or FormatNumber *or another function which is capable to align in the way explained. THANKS VERY MUCH. -- kaokao1 ------------------------------------------------------------------------ kaokao1's Profile: http://www.excelforum.com/member.php...o&userid=35005 View this thread: http://www.excelforum.com/showthread...hreadid=548435 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Align to the left or to the right (or center)
Range("C2").HorizontalAlignment = xlLeft Range("C2").HorizontalAlignment = xlCenter Range("C2").HorizontalAlignment = xlRight |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Align to the left or to the right (or center)
It works!!! OK. Friend. THANKS VERY MUCH -- kaokao ----------------------------------------------------------------------- kaokao1's Profile: http://www.excelforum.com/member.php...fo&userid=3500 View this thread: http://www.excelforum.com/showthread.php?threadid=54843 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| Center Align | Excel Programming | |||
| Left align '$' and right align numbers? | Excel Discussion (Misc queries) | |||
| align text in the center of a range of cells | Excel Programming | |||
Linear Mode
