Extracting data from Merged Cells

[zloywolf]

Need help writing a macro for extracting data from merged cells.

I have an Excel file with multiple tabs. Each tab has the exact same layout. Some cells with data are merged. I would like to run a macro that will go through all the tabs and unmerge the cells but keep the cell data originally there.
I've attached an example of the file.
I appreciate any help!
Thank you! test_unmerge.xls

[protonLeah]

If you select the entire sheet and click unmerge, the data in each group of merged cells will be moved to the first cell of that range after the unmerge event.

[zloywolf]

Ah, that was simple enough. Thank you. Would it be possible to create a macro that will run this command on all worksheets as soon as a user open up this workbook? Or, if it is better to create a button a user can press once in the workbook, which will run the macro.

[jaslake]

Hy zloywolf

Try this

Please Login or Register  to view this content.

Place the code in ThisWorkbook Module.

[zloywolf]

Thank you! It worked perfectly.

[jaslake]

You're welcome. If that satisfies your need please mark your Thread as SOLVED.