VBA Code to Center Data

[Justinian]

I am trying to center data in column A, C, D, and E with a macro. I am using the code below but the sort will not work so I am not sure what I did wrong. Can anyone help?

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]Range("A2,C2:E2" & Cells(Rows.Count, "E").End(xlUp).Row)[/FONT]
<strike></strike>

 

[Fluff]

How about

   Range("A:E").EntireColumn.HorizontalAlignment = xlCenter

 

[Justinian]

I am only centering A, C, D, and E, not A:E.

 

[Fluff]

In that case

   Range("A:A,C:E").EntireColumn.HorizontalAlignment = xlCenter

 

[Justinian]

Thank you so much!

 

[Fluff]

You're welcome