JW,

Thanks for your help. The code works perfectly.

"JW" wrote:

Fo just A1:C1
Range("A1:C1").HorizontalAlignment = xlCenter

For the whole first row
Rows(1).HorizontalAlignment = xlCenter

AccessHelp wrote:
I have values in Cells A1, B1 and C1 in a new sheet. How can I align them to
center? I have tried the following:

NewSheet.Rows(1).align msoAlignCenter, true

Thanks.