John,
i see two codes in the one above you provided?
And when i enter in the code excel asks me which one i want to run?
I choosen both to see which one works.. Merge cell seems to work a little better, i believe,

Is there a reason why you put two codes in?

Let me know., as far as the code, so good so far.. just want to make sure which one i use before i start using it on multiple worksheets...