Hi Gordon,

Am Thu, 12 Feb 2015 07:46:35 -0600 schrieb Gordon:

After further digging into this problem I think I have it resolved.
I had somehow set the sheet up for sharing and this seems to have
locked the merge function down. When I removed the shared setup it
seems to have worked okay. I'll keep after this and let you know if
this has fully resolved the problem. Don't know how it got set up as
shared but I'm guessing I clicked on the wrong thing somewhere along
the way.

yes, that is another cause for that problem.
But with merged cells you can come in trouble if you want to sort or
to filter.
I prefer to select the cells = format cells = Alignment =
Horizontal Alignment: Center across selection


Regards
Claus B.

I add a custom menu just for doing that, and is my preference also!<g

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion