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.

<tbody>
</tbody>

Dropdown List

Code Name	Code No	Code Rate	Total Amount		Drop Down List
					AB | 02 | 0.10%
					AC | 05 | 0.013%
					AF | 15
					BR | 65

<tbody>
</tbody>

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