You can Merge UnMerge Cell Range in Excel VBA, it is required if you want to make bigger cells, instead of existing cell to fit your data and needs.
We can use Merge and UnMerge methods of a Range to Merge UnMerge Cell Range in Excel VBA.
Following is the example to show you how to merge or UnMerge the cells in excel using VBA.
Code to merge Cells
Code to unmerge Cells
- Open an excel workbook
- Press Alt+F11 to open VBA Editor
- Insert a Module for Insert Menu
- Copy the above code and Paste in the code window
- Save the file as macro enabled workbook
- Press F5 to execute it