More efficient way to format a column?

[Jen5309]

Hi -

Does anyone know of a more efficient way to code this formatting of a column? It works fine, I just wanted to know if there is a better way of doing this.

Thanks!

Just a piece of the code:

Please Login or Register  to view this content.

[VBA Noob]

Maybe

Please Login or Register  to view this content.

VBA Noob

[Simon Lloyd]

Maybe a little neater is this:

Please Login or Register  to view this content.

of course if you don't need to do all the actions listed you can remove them, i added .AutoFit so the column fits to the length of word in the column but you can take it out and put your column width back in.
It's worth remembering that you do not have to select things in order to manipulate them, as you see above i haven't selected anything (excel runs a little quicker this way), try changing activesheet to another sheet name like: Sheets("Sheet1") but have your activesheet as say sheet 3 run the code and you will find that your sheet that you are viewing did not chnage but the action was performed on the designated sheet.

[Jen5309]

Thanks guys, those worked out great!