Merged Cells Removing 1

[robcarr]

Dear All,

I have to paste approx 400 rows most days into a sheet, on the odd occassion the data I am pasting contains merged cells, I then have to sort the data, when I try to sort the data, it says "merged cells need to be indentical" (or similar). I was hoping I could run some coding and if it finds a merged cell(s), it removes the merge, the data in the merge cells is always blank, can anyone help with this.
Thanks

 

[tomschafer]

Simply put this bit of code into the top of your code to unmerge the cells.

Cells.UnMerge

 

[robcarr]

thanks for doing this, really simple really.

rob