Thanks to all of you for your solutions, all of which work!

Bill


"Bill Murphy" wrote in message
...
I have merged 5 cells horizontally with:

objSht.Range("A1:E1").Merge
objSht.Cells(1, 1) = "My Report Title"

How can I center the report title in the merged cells?

Bill