un merging

  • Thread starter Thread starter Noctos
  • Start date Start date
Noctos,

Try something like the following, where A1 is the top left cell
of the merged area.

Range("A1").MergeCells = False



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
With VBcode, select the cell to unmerge

With Selection
.HorizontalAlignment = xlLeft
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.MergeCells = False
End With
 
You must log in or register to reply here.

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
create macro "merge selected cells"? 7
unmerge with macro 2
Merged Cells Question 4
macro to unmerge cells 6
Excel Merge Cells 2
Spreadsheet with merged cells - how can I unmerge the cell and re. 1
wildly varying execution speeds - is it the code? 3

Back
Top