how do i center text in a cell using excel using a code rather th.

L

Lisa T

I would like to center text in a field in excel but center using a code
rather than the center align button on the toolbar.
 
P

Paul B

Lisa, something like this

Sub Center_Text()
With Selection
.HorizontalAlignment = xlCenter
End With
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
 
Top