Align to the left or to the right (or center)

K

kaokao1

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.
 
W

ward376

Range("C2").HorizontalAlignment = xlLeft
Range("C2").HorizontalAlignment = xlCenter
Range("C2").HorizontalAlignment = xlRight
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create merge cells from table definition 10
Align picture to the right side of a cell... 1
Save As HTM with "align=Left" in HTM file code 2
Center the Column Headers 7
Align the form to the top left 5
How can I align pictures to the columns in code 1
align autoshape with centre / right of excel cell 2
Format Cell 4

Top