thanks tghcogo....yes im sure they are merged. The manual unmerge works fine.
I looked at the macro code..and it did not have an "unmerge" command. I
changed the code to select the columns and issued "unmerge" and it worked. So
I dont know what is going on with the record macro function

"tghcogo" wrote:


Hmmmm not sure what's happening. Are you sure the cells you are
unmerging are merged (probably a daft question), merge/unmerge is a
toggle.

Keyboard strokes are better than the mouse when using the record macro
function, eg


Ctrl+1
Alt+m
Enter


--
tghcogo
------------------------------------------------------------------------
tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=491561