unmerge cells

[Brian Matlack]

Hi!
I have a sheet that contains 50 merged cell groups and I want to unmerge them all at once. When I record the macro I select the entire sheet and then unmerge the cells all at once. The recorded macro is about a mile long.

Is there a shorter code that would take care of this for me?

As always, this rookie would be grateful for any and all help.
Thanks!!!

[JE McGimpsey]

One way:

Cells.UnMerge


In article
<[email protected]>,
Brian Matlack
<[email protected]> wrote:

> Hi!
> I have a sheet that contains 50 merged cell groups and I want to
> unmerge them all at once. When I record the macro I select the entire
> sheet and then unmerge the cells all at once. The recorded macro is
> about a mile long.
>
> Is there a shorter code that would take care of this for me?
>
> As always, this rookie would be grateful for any and all help.
> Thanks!!!