Thank you kev.

I have resolved it.

I have changed the range from 1 column at the time to all needed to unmerge and wrapped it around with that code regarding alerts. Then reapplied the merging for each at a time and instead of copying and pasting I have done each column as merge + copy and paste Formats + paste formulas and it worked.

Thank you for your help.

Appreciate it.