Did you try recording a macro while doing it manually

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"AccessHelp" wrote in message
...
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.