Although your code works fine it is also a bit ugly

but you should look at:
HorizontalAlignment = xlRight

Tip: if you start the macro editor and record a macro doing what yopu
want to achieve and stop it the vba code of this macro is stored in a
new module.


--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=397464