Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
un merging
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merging | Excel Discussion (Misc queries) | |||
Merging | Excel Discussion (Misc queries) | |||
Merging | Excel Discussion (Misc queries) | |||
When merging information not merging correctly | Excel Worksheet Functions | |||
Sorting, Merging, and Re-merging | Excel Worksheet Functions |