Finding Merged Cells

[Don Edmondson]

Is there any (easy) way of finding a cell or cells that
have been merged?
I am trying to sort a (very large) spreadsheet but can't
because Excel "...requires the merged cells to be the same
size..."

I can always select all and remove the merge - but I am
wondering why there are merged cells - hence the reason
for trying to find them!

 

[DonE]

Many Thanks - I like the macro solution - it certainly
works on a test setup - I'll try it on the real
spreadsheet tomorrow

 

[Guest]

Thanks alot Don! Really helped me out in a crunch.