Merged Cell Problems

To avoid merging cells (because I need to run a number of sort and sum functions for the given column) I quick wrote a work around that would treat a range of cells as though it was merged without actually merging them.

Please Login or Register  to view this content.

I then center across AH1:AM1. While it works great, I encountered a couple of problems:

Problem 1: Say for example I want to select range A1:AS39 to copy and paste. Since AH1:AM1 is in that range it will move the cursor to AH1 every time. Is there a way around that problem? I need it such that if any cell outside the range set is selected it disregards the code.
Problem 2: How do I keep this code simple, but apply it to every row in the columns I outlined? Not just for AH1:AM1 but for every row (AH2:AM2, AH3:AM3, etc.)

If you have a better way of handling merged cells, please let me know!

Thanks. That did the trick.

You're welcome! Thanks for the rep, and thanks for marking your thread Solved!