Merge unmerged particular cells with macro

[pincivma]

I unmerged about 500 merged cells in a worksheet by running the below macro. I did this so that I could run another macro that was giving me problems due to these 500 merged cells. But after I run the macro, I need to merge all those 500 cells again. Is there a macro that can do that? I do not want to waste hours merging all those 500 cells that I unmerged. Thanks

Sub UnmergeAllCells()
ActiveSheet.Cells.UnMerge
End Sub

 

[Michael M]

Re: Merge unmerged paqricular cells with macro

Depends on where the merged cells are !
There is no quick fix, but if the cells are in consistent rows / columns a loop MIGHT be able to get it done.
Otherwise tying in all the ranges to merge would take as long as it would to do the merges manually.

Having said all that I'd avoid merged cells at any cost, as they create havoc in spreadsheets, sorting, filtering, copying !!!

 

[pincivma]

Re: Merge unmerged paqricular cells with macro

Thanks for your answer. Most of the merged cells are on every other row. I don't know how to use the mod function in a macro to merge them back.

 

[Michael M]

Re: Merge unmerged paqricular cells with macro

you would need to provide more detail on the locations of the merged cells for anyone to assist further.