View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default unmerge with macro

Record a macro when you select all the cells and remove the merged cells (from
the alignment tab of the format dialog).

Alfred wrote:

Hi
Is it possible to write a macro to find all merged cells and then either
delete them or unmerge them.
Thanks for help
Alfred


--

Dave Peterson