How to unmerge all cells in one go using VBA in Excel

In this tutorial you will learn how to unmerge all cells in one go using VBA macro programming in Microsoft Excel

VBA Code:

'This code will unmerge all the merged cells
Sub UnmergeAllCells()
ActiveSheet.Cells.UnMerge
End Sub