un merging
 

do any of you know how to unmerge a cell


---
Message posted from http://www.ExcelForum.com/

un merging
 

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


"Noctos" wrote in message
...
do any of you know how to unmerge a cell


---
Message posted from http://www.ExcelForum.com/

un merging
 

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


"Noctos" wrote in message
...
do any of you know how to unmerge a cell


---
Message posted from http://www.ExcelForum.com/