select the cell
With Selection
.HorizontalAlignment = xlLeft
End with

"k483" wrote:


what's the correct vb syntax for left-aligning the text in a cell?

thanks

k483


--
k483
------------------------------------------------------------------------
k483's Profile: http://www.excelforum.com/member.php...o&userid=10791
View this thread: http://www.excelforum.com/showthread...hreadid=386434