View Single Post
 
Old 11-09-2019, 09:05 AM
Bumba Bumba is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Jan 2019
Posts: 26
Bumba is on a distinguished road
Default How to unmerge all merged cell and fill them with the merged values?

I have a workbook that has merged cells in it.

How do I unmerge all the merge cells in that workbook and fill those unmerged cells with the value its parent merge cell had in a different workbook in the same location using VBA.

I know to unmerge all cells in sheet I can use:

Quote:
ActiveSheet.Cells.UnMerge
But how to do the rest?
To better understand I have attached the merged file & unmerged file(final output file).

Please help.
Attached Files
File Type: xlsx merged DATA.xlsx (8.9 KB, 6 views)
File Type: xlsx unmerged DATA.xlsx (8.9 KB, 6 views)
Reply With Quote