VBA CODE to Unmerge multiple cells on entire Sheets

**teachMeExcel** · 09-21-2013, 05:28 PM

Hi ! I am new to writing VBA Codes, im looking for a vba code to Unmerge an entire sheet. I have a huge sheet that contains a lot of merge cells and II need to unmerge all those cells.
Very much appreciative if anyone can help me find a code for that problem.

**coreytroy** · 09-21-2013, 05:56 PM

Try using the recorder, when selecting the entire sheet(header point between A & 1) then un-merge cells.

**stanleydgromjr** · 09-21-2013, 06:03 PM

teachMeExcel,

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code
2. Open your NEW workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Please Login or Register  to view this content.

Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm

Then run the UnMergeAllCells macro.