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

[Guest]

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.

 

[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

 

[Don Guillett]

Just record the action