[Solved] VBA: Determining merged cell ranges

I would first say, avoid merging cells in Excel as it will often cause grief. A better option is the Center Across Selection via Format>Cells>Alignment- ...

www.ozgrid.com