MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Column alignment


Posted by Antonio on February 21, 2001 9:24 AM

Hello everybody.

I need to change the columns alignment in a sheet (left,right,center), and I can't find the correct method or property in the VBA Excel Reference. Anybody could help me?

Thanks very much.


Posted by Faster on February 21, 2001 9:34 AM

Selection.HorizontalAlignment = xlLeft

Selection.HorizontalAlignment = xlRight

Selection.HorizontalAlignment = xlCenter