From the author: 'To use the Merged Cell Finder macro, open the
attached file and leave it open while you go to the sheet on which you
want to find all of the merged cells. Then run the "FindMergedCells"
macro by doing a Alt+F8 and selecting the macro and clicking "Run" or
from the toolbar do a TOOLS MACRO MACROS and select the macro and
"Run" as before.

The macro will add a new sheet to your workbook with the List of Merged
cells. It will not overwrite an existing sheet, so if you want to run
it a second time for the same sheet, it will bomb unless you first
delete the previously created sheet or rename it.'


From me: This saved HOURS of goofing around, editing others'
spreadsheets. So good, I offered to pay for it.


http://www.ozgrid.com/forum/showthread.php?t=22501
Free 58k macro