Merge and Unmerge Cells

[Bluwara]

Morning all,

I want to know the vba code to merge and unmerge cells. The following table is the information I have.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Dropdown List

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Code Name
[/TD]
[TD]Code No
[/TD]
[TD]Code Rate
[/TD]
[TD]Total Amount
[/TD]
[TD][/TD]
[TD]Drop Down List
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]AB | 02 | 0.10%
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]AC | 05 | 0.013%

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]AF | 15
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]BR | 65
[/TD]
[/TR]
</tbody>[/TABLE]


Merge option

Merge option

Unmerge option
Unmerge option



As you can see from the table, There is 1 drop down menu that has 2 different selection options. One is the merge option and the other is the unmerge option.

When I input a value from another cell, it triggers one of the 2 (merge or unmerge) options to show on the drop down list. This part I have done.

What I am trying to achieve is when the merged option is selected and when I pick an item from the drop down list, row cell from Code Name/Code No/Code Rate all merge. And then auto move on to the next row to fill another row with the next merge selection.

Likewise to the unmerge option, when I select an item from the drop down list the Code Name/Code No/Code Rate will be filled in from their drop down lists.

Hope this is clear and thanks in advance.


Bluwara

 

[RedBeard]

Merge: https://msdn.microsoft.com/en-us/vba/excel-vba/articles/range-merge-method-excel
Unmerge: https://msdn.microsoft.com/en-us/vba/excel-vba/articles/range-unmerge-method-excel