macro to unmerge columns
 

A recorded macro for unmergin 2 merged columns in a worksheet doesnot work.
It tries to merge the cells again and as a result wipes out the data.

macro to unmerge columns
 

Show us the code.


Gord Dibben Excel MVP

On Wed, 7 Dec 2005 10:42:02 -0800, "HankY"
wrote:

A recorded macro for unmergin 2 merged columns in a worksheet doesnot work.
It tries to merge the cells again and as a result wipes out the data.

macro to unmerge columns
 

I dont have the code available right now(at home) but the code in the
recorded macro had a"merge" command in it. I changed the code to select the
columns and did an "unmerge" and it worked correctly. If I go thru the same
steps without recording the macro..the columns/cells are unmerged correctly.

"HankY" wrote:

A recorded macro for unmergin 2 merged columns in a worksheet doesnot work.
It tries to merge the cells again and as a result wipes out the data.