Related Blog Posts On Merged Cells
To Merge Or Not To Merge That is The Question
How To Find Merged Cells In Excel
What Does The Macro Do?
This macro is really simple and is designed to remove the merged property from a range of cells selected by the user.
How Does It Work?
This macro uses the umerge method which separates a merged area into individual cells. So let’s get coding. First we need to open Visual Basic – by hitting ALT +F11 or Developer Tab – Visual Basic – Insert Menu – Module
Step 1. Declare Our Variables. We have one two Object Variables in this Macro. We are declaring the active worksheet and the range of cells.
Dim ActWorksheet As Worksheet
Dim MyRange As Range
Step 2. We now store the current worksheet and the selected range of cells.
Step 3. We now un-merge any merged cells in the selected cell range, the macro now ends.
That’s it now time to test the macro!
Want To Copy The Code?
If you want to see all of my blog posts in the Macro Mondays Series you can find them all in the link below. Why not book mark it?, Yes it is updated EVERY Monday.
You can also download the corresponding example workbook that contains the Macro code by clicking on the download button below.