Select and merge cells with duplicate values
 

Hi,

I am looking for a macro that selects all cells with the same value an
merges these cells.
In row5 (not in a column!) I have a some values, from 1 to 14. Th
values are sorted ascending. When there are five values "1", the macr
should select all these cells with duplicate values and merge them.
The problem is I don't know how to do this.
Can someone help me with this problem? Thanks in advance

--
leonida
-----------------------------------------------------------------------
leonidas's Profile: http://www.excelforum.com/member.php...fo&userid=3537
View this thread: http://www.excelforum.com/showthread.php?threadid=57425