unmerge with macro

  • Thread starter Thread starter Alfred
  • Start date Start date
A

Alfred

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
 
Record a macro when you select all the cells and remove the merged cells (from
the alignment tab of the format dialog).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vb code to clearcontents of a merged cell 8
unmerge cells 1
macro to unmerge cells 6
create macro "merge selected cells"? 7
MACRO - Unmerge cells and delete blank columns, leaving data colum 5
Excel Macro 1
Spreadsheet with merged cells - how can I unmerge the cell and re. 1
want help 3

Back
Top