HorizontalAlignment = xlCenter ?

[DougStroud]

Can this line be written as one? I have tried altering the syntax, but that is not the answer.

Columns("M:P", "U:V").HorizontalAlignment = xlCenter

Thanks,

Doug

 

[ExcelChampion]

Range("M:P,U:V").HorizontalAlignment = xlCenter

FYI, I got this from the macro recorder. No matter how good you get, its still a good tool.

 

[DougStroud]

Thanks Todd