Left Justify Cell

R

Ron K

Can someone tell me how to programatically left justify a
cell. Actually, if all of the cells were left justified
that would be even better.
My problem is when my character data contains all
numerics, the data is right justified. When the data
contains at least one alpha character, it is left
justified. This causes the work sheet not to look very
nice.
Thanks.
 
P

Philip Mariconda

Range("A1:C9").HorizontalAlignment=xlHAlignLeft
Use with any valid range. Keep in mind that certain
number formats such as accounting can throw this off.

Phil
 

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

Combine two cells without losing data cell formats 3
Automatic copy of cell formatting between sheets 0
Copy Data From Excel Into a MSWord Document 4
no justify? doesn't make sense.... 5
Combination of left and right justification in a cell? 2
Date formatting 1
Further Challenges with Footers and automatic text wrapping 1
Dollar sign left justified - data right justified - large space 3

Top