The person might be satisfied with Center Across Selection which causes no
problems as merged cells do.


Gord

On Sat, 12 Dec 2009 17:16:01 -0800, Trish Smith
wrote:

Thanks for trying it out Gord.

It was a merged range on one of my sheets. I try to avoid merging cells but
the person I'm doing the workbook for wants a horizontal title over a number
of rows.

I've added rows at the top to get over this.

Thanks again